Microsoft® SQL Server 2012 Unleashed

What’s New in SQL Server Disaster Recovery Planning

Microsoft’s solution to DR now emanates in the AlwaysOn features as well as with some Azure options (to use the cloud as a viable recovery site). In addition, they continue to release enhancements to existing features that are highly leverageable on various approaches to DR in many SQL Server environments. In particular, a peer-to-peer replication model to their data replication offering is of high interest with regard to creating active/active DR solutions as well as a Change Data Capture (CDC) approach as a poor-man’s approach. Database mirroring (even though it will be deprecated someday) is also another viable feature that can be used to support both active/active and active/passive DR ...