What’s New in SQL Server Disaster Recovery Planning

Microsoft still hasn’t really introduced a specific new feature that says “disaster recovery” on it. But the company continues to release enhancements to existing features that can be leveraged on various approaches to disaster recovery in a SQL Server environment. In particular, a peer-to-peer replication model to the data replication offering is of high interest in regards to creating active/active disaster recovery solutions. Database mirroring (along with database snapshots) is also another feature that can be used to support both active/active and active/passive disaster recovery needs. These, and other more traditional offerings, round out the arsenal from Microsoft for giving you the ...

Get Microsoft® SQL Server 2008 R2 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.