New SQL High Availability and Disaster Recovery Whitepaper

There is now a great new whitepaper by Paul Randal on Proven SQL Server Architectures for High Availability and Disaster Recovery that extends the scope of his existing High-Availability with SQL Server 2008 white paper currently on msdn to include real world examples using case studies.

This document unpacks each of the following scenarios and provides examples of a customer implementation:

  • Failover Clustering for High Availability with Database Mirroring for Disaster Recovery
  • Database Mirroring for High Availability and Disaster Recovery
  • Geo-Clustering for High Availability and Disaster Recovery
  • Failover Clustering for High Availability Combined with SAN-Based Replication for Disaster Recovery
  • Peer-to-Peer Replication for High Availability and Disaster Recovery

<Gary>