CHAPTER 11 Data Recovery Strategies

In this chapter, you will learn about:

• How data recovery fits into a disaster recovery plan

• Transaction log

• Recovery models

• Backups

• Restores

• Backup strategies for system databases and scripts

Who is General Failure, and why is he reading my hard disk?

—Steven Wright

For all of us, it's just a matter of time before we come across an error such as "General failure reading data on drive x:" or otherwise lose some data. The difference between this event being a minor inconvenience or a major catastrophe depends on our backup strategy and our ability to restore the lost data.

In the previous chapter, we learned about many different high-availability strategies such as log shipping, database mirroring, ...

Get MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.