Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
AlwaysOn Availability Groups
With SQL Server 2012, much hype is being made about the AlwaysOn option. For DR, the use of the AlwaysOn Availability Groups to replicate data to other locations for DR is becoming the new path for many. AlwaysOn has actually taken the best from database mirroring and SQL clustering and married the two together to give a wide array of configuration options for both high availability and for DR. As you can see in Figure 59.13, one active site (primary replica) can replicate its data to another secondary site (secondary replica) within the same major network (across network subnets). The secondary site (secondary replica) can be used as a read-only database readily. If the primary site fails (a disaster), the secondary ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access