Microsoft® SQL Server™ 2005 Administrator's Companion

Summary

We’ve examined the basics of MSCS and how SQL Server works within that architecture. We’ve also seen how SQL Server can survive some types of catastrophic hardware and software failures and be back up and running transactions in a short time. To achieve this degree of fault tolerance, you must not only enable MSCS but also take other measures. Two important steps are performing regular and effective backups and preparing a disaster recovery plan. The procedures for backing up your system and preparing a disaster recovery plan are described in detail in Chapter 14, and Chapter 15, as well as Chapter 27. Clustering servers and creating RAID storage are not alternatives to performing backups. In many cases, neither of these technologies can ...