CHAPTER 10Disaster Recovery

In this chapter, you will learn about:

• Disaster recovery

• Transaction log

• Recovery models

• Backups

• Restores

• Detach and attach

• Log shipping

• Database snapshots

• Database mirroring

Insurance is something you always want to have, but never want to use.

—Jack Grzena

Disaster preparedness and business continuity are a significant part of any IT professional's overall strategy. We need to keep systems up and operational as much as possible when they are expected to be up and operational. When the unexpected happens, we need to be able to respond quickly and efficiently to restore the systems.

Just like having insurance, we want to be prepared for disasters, but we never want them to happen. Preparedness ...

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