CHAPTER 10 High-Availability Strategies

In this chapter, you will learn about:

• Log shipping

• Database snapshots

• Database mirroring

• Replication

• Clustering

Any sufficiently advanced technology is indistinguishable from magic.

—Clarke's Third Law

While not exactly magic, to the uninitiated, many of the strategies used to maintain separate copies of databases certainly seem to be magical. An entire database could go down, but the end user is barely aware there was even a problem.

image TIP This chapter deals with high availability, and the only way to demonstrate this is with two separate instances of SQL Server. In the real world, this would ...

Get MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) 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.