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.
Enjoy!
PS Checkout our 5-day class in Bellevue, WA in August – see here.
5 thoughts on “Whitepaper on high-availability architectures published”
Hi Paul,
What’s your opinion the Neverfail’s SQL HA product? Did you have any experience with it?
Thanks,
Av
Av – no publicly-expressable opinion on any 3rd-party HA products, as a rule, unless asked face-to-face in a class.
Hi Paul, this is very nice list with lot of stuff! Thank you for the info!
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
No idea – I’m not a cluster internals expert.