Disaster Recovery, Master Backup Not Available

Microsoft SQL Server Virtual Backup

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.

    }