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