Chapter 31. AlwaysOn

After completing this chapter, you will be able to

  • Understand the improvements in failover cluster instances.

  • Create AlwaysOn Availability Groups.

  • Administer AlwaysOn Availability Groups.

  • Read secondary database copies.

With high availability and disaster recovery becoming priorities in corporate IT departments, there has been a need for a more robust set of solutions compared to the built-in solutions in previous versions of SQL Server prior to Microsoft SQL Server 2012. Oftentimes, one or more technologies had to be combined to satisfy requirements for true high availability as well as disaster recovery. In SQL Server 2012, Microsoft released a set of solutions under the AlwaysOn umbrella. This solution combines improvements ...

Get Microsoft® SQL Server® 2012 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.