Microsoft SQL Server Virtual Backup Device Specification
Disaster Recovery, Master Backup Not Available
The entire server is being recovered after a catastrophic failure. A current conventional backup of master is not available. Full database snapshots and conventional log backups are available for some user databases.
Steps
- Restore Microsoft® SQL Server™ service. (This may require restore from a file system backup or a reinstall.)
- Restart server normally.
- Recreate objects in master, but do not create user databases for which there are backups (snapshot or conventional).
- Fix or restore MSDB and model as required.
For each database to be restored {
Restore database with norecovery.
Apply log backups and recover.
}