Chapter 6High Availability

The concept of high availability is quite simple: Systems must stay up as much as possible (in some cases, constantly). This requirement is not only aimed at unexpected events such as system failures but also for planned downtimes such as maintenance or upgrades.

Microsoft provides a wide array of features within its operating systems and in SQL Server 2005 that can help you accomplish that goal. The mechanism you choose depends on what level of availability you are after and which parts of the system you want available.

For duplication of data across several servers, you can copy data automatically from one place to another using replication. Several types of replication bring data from one server to many or to both ...

Get Administrator’s Guide to SQL Server 2005 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.