Microsoft® SQL Server 2012 Unleashed

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 ...