O'Reilly logo

MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) by Darril Gibson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required