Whitepaper on high-availability architectures published

The 20-page whitepaper I wrote this Spring for the SQL team has just been published. This whitepaper is titled Proven SQL Server Architectures for High Availability and Disaster Recovery and ties in with the longer whitepaper I wrote last year on High Availability with SQL Server 2008 (see here).

This new whitepaper describes the five most commonly deployed high-availability and disaster-recovery architectures deployed by customers, along with a case study of each. It covers:

  • 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

You can get it from this link.


PS Checkout our 5-day class in Bellevue, WA in August – see here.

5 thoughts on “Whitepaper on high-availability architectures published

  1. Hi Paul,

    What’s your opinion the Neverfail’s SQL HA product? Did you have any experience with it?


  2. Av – no publicly-expressable opinion on any 3rd-party HA products, as a rule, unless asked face-to-face in a class.

  3. Hi Paul,

    1 Question I have related to Windows 2008 Cluster for which I am not able to get Answer anywhere..

    Is there ANY ARCHITECTURAL DIFFERENCE IN WINDOWS 2003 CLUSTER AND WINDOWS 2008 CLUSTER specially in terms DLLs used by Core Component of WIndows CLuster..

    For E.g Does Windows 2008 Cluster Uses same Architecture and same DLLs like below..??
    Volume Shadow Copy Service Task
    Resource DLL: VSSTask.dll
    Extension DLL: VSSTskEx.dll

    DHCP Service : Resource DLL: Clnetres.dll
    WINS Service : Extension DLL: Clnetrex.dll

    Could you please provide me any Link for Learning Core Architecture of Windows 2008 Cluster?

    Thanks in advance,
    Vivek Sharma
    Pune, India

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.