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.
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.