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

Data Replication and Database Mirroring or AlwaysOn Features for Fault Tolerance and High Availability

SQL Server 2012 allows you to use combinations of options to achieve higher availability levels. AlwaysOn failover instances and Availability Groups are the heart of this high availability capability for SQL Server 2012. All replication options operate within (can be combined with) the AlwaysOn configuration capabilities. In addition, you can also combine data replication with database mirroring to provide maximum availability of data, scalability to users, and fault tolerance via failover at potentially each node in the replication topology. You can start with the publisher and distributor, making them both database mirror failover configurations. ...

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