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. ...
Get Microsoft® SQL Server 2012 Unleashed 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.
