In this chapter, you will learn about:
• How data recovery fits into a disaster recovery plan
• Transaction log
• Recovery models
• Backup strategies for system databases and scripts
Who is General Failure, and why is he reading my hard disk?
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, ...