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

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.