High Availability Solutions (SQL Server)
This topic introduces several SQL Server high-availability solutions that improve the availability of servers or databases. A high-availability solution masks the effects of a hardware or software failure and maintains the availability of applications so that the perceived downtime for users is minimized.
For information about which editions of SQL Server support a given high availability solution, see the "High Availability (AlwaysOn)" section of Features Supported by the Editions of SQL Server 2012.
In this Topic:
SQL Server provides several options for creating high availability for a server or database. The high-availability options include the following:
Our recommendation for providing data protection for your SQL Server environment are as follows:
For data protection through a third-party shared disk solution (a SAN), we recommend that you use AlwaysOn Failover Cluster Instances.
For data protection through SQL Server, we recommend that you use AlwaysOn Availability Groups.
If you are running an edition of SQL Server that does not support AlwaysOn Availability Groups, we recommend log shipping. For information about which editions of SQL Server support AlwaysOn Availability Groups, see the "High Availability (AlwaysOn)" section of Features Supported by the Editions of SQL Server 2012.