Microsoft SQL Server 2000 High Availability Series

Updated : November 19, 2002

The Patterns & Practices team has decided to archive this content to streamline content offerings and keep focused on the newest, most relevant content. However, we will continue to make this content available because it is still of interest to some users. We offer this content as-is, without warranty that it is still technically accurate as some of the material may be outdated. Note that the content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.


The Microsoft SQL Server 2000 High Availability Series helps you plan and deploy a highly available data center that uses Microsoft SQL Server 2000 through proper procedures that increase availability, backups help recover from catastrophic disasters, redundant components prevent downtime, and redundant servers minimize downtime.

The series consists of:

  • PLANNING to help you design a data center to achieve the level of availability needed for the business environment.

  • DEPLOYMENT to help you implement selected server redundancy solutions to minimize unavailability caused by server failures and planned downtime.



Introduction to High Availability
Overcoming Barriers to High Availability
Recovering a Data Center by Using Database Backups
Preventing Downtime by Using Redundant Components
Minimizing Downtime by Using Redundant Servers
Contents of a Run Book


Implementing Failover Clustering
Implementing Log Shipping
Implementing Transactional Replication
Implementing Network Load Balancing
Implementing Remote Mirroring and Stretch Clustering


The Microsoft SQL Server 2000 High Availability Series is designed for business decision makers, Microsoft Certified Solution Providers, Microsoft Consulting Services, IT professionals, and developers responsible for application or infrastructure development and deployment.

This series assumes you have a basic understanding of the following areas of SQL Server 2000 and Microsoft Windows 2000 operating system: Windows 2000 Active Directory service and DNS, Microsoft Cluster Service (MSCS), Database design for online transaction processing (OLTP) and online analytical processing (OLAP), application design for databases, SQL Server operational procedures, SQL Server backup and restore procedures, SQL Server security model, Redundant Array of Independent Drives (RAID), Storage Area Networks (SANs), and Network Load Balancing (NLB) .