Home > Articles > Data > SQL Server

  • Print
  • + Share This
This chapter is from the book

Summary

By having a carefully documented and tested recovery plan, restoring a server after a comprehensive failure doesn't have to be a gut-wrenching experience.

I strongly suggest that at the very least, you back up the master and msdb databases in addition to your user databases with every backup. Both databases are very small and will make your recovery experience easier.

If possible, you could also back up the databases (master and msdb) to a local disk drive and tape. This would make recovery even faster. Since both are small, it would be easy and fast. As a precaution, you would need to put the backup on a different disk than the database—if you lost the database disk, you would also lose your disk backups!

Using this chapter in conjunction with the previous chapter, you should have most critical recovery scenarios covered.

  • + Share This
  • 🔖 Save To Your Account