- Rebuilding and Recovering the <tt>master</tt> Database
- Potential Problems in Rebuilding and Restoring the <tt>master</tt> Database
- Recovering Other Databases after <tt>master </tt> Has Been Rebuilt
- Notes on Logins and Users after a <tt>master</tt> Rebuild
- Program to Generate Logins from the User Database
- Remapping Orphaned Users
- Recovering msdb
- Summary
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 databaseif 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.