Clustering Concepts

As a database administrator, your primary job is to keep the database up and running optimally during specific time periods, which are usually outlined in a service level agreement. This service level agreement probably specifies the amount of uptime your system must provide, as well as performance rates and recovery time in the event of a failure. Using MSCS can increase the amount of uptime and decrease recovery time. Although server hardware, Windows 2003, and SQL Server are usually stable and reliable, components sometimes fail. In fact, a variety of types of failures can occur in a complex computer system, including the following:

  • Disk drive failure. Disk drive technology has improved, but a disk drive is still a mechanical ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.