I’d like to share today two very important whitepapers published on the SQLCAT team site. Both of them are regarding high availability solutions – design and real-life examples.
The first one is Failure Is Not an Option: Zero Data Loss and High Availability and describes “how to combine SQL Server high availability technologies to provide a zero data loss, highly available solution for database applications involving financial transactions”. The whitepaper can be downloaded from here.
The second one is on written by Paul S. Randal (SQLskills.com) and is called Proven SQL Server Architectures for High Availability and Disaster Recovery. It applies to SQL Server 2005, 2008 and 2008 R2 and “describes five commonly-deployed architectures using SQL Server 2005 and SQL Server 2008 that are designed to meet the high-availability and disaster recovery requirements of enterprise applications. The whitepaper will describe the architectures and also present case studies that illustrate how real-life customers have deployed these architectures to meet their business requirements”. Download the whitepaper here.