Chapter 9. High Availability, High-Performance SQL Server Solutions

Introduction

It’s all about data. And for Microsoft’s data technolgy, it’s all about SQL Server. No matter what the IT shop is supporting—home-grown client applications, CRM, Web applications, enterprise, and line-of-business—SQL Server 2000 and SQL Server 2005 are the only Microsoft database technologies engineered to provide a highly available data tier.

Before we explore the data tier further, it should be noted that this chapter has been based mostly on SQL Server 2000. While SQL Server 2005 can obviously support clustering, the product had not been issued as beta at the time this chapter was written. Although we have been working extensively on the recent beta and alpha versions, ...

Get Building High Availability Windows Server™ 2003 Solutions now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.