O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required