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.