One configures SQL Server for high availability (HA) in anticipation of some event that will cause a critical application to go offline unexpectedly—a software glitch that causes an app to freeze or a fault in storage that brings down a disk, for example. A well-designed HA solution will cause a secondary instance of your application and database infrastructure—running in a nearby but geographically distinct data center—to assume your critical loads and keep your operations running smoothly, with no loss of data.
READ MORE