Disaster Recovery, Master Backup Available

Microsoft SQL Server Virtual Backup

Microsoft SQL Server Virtual Backup Device Specification

Disaster Recovery, Master Backup Available

The entire server is being recovered after a catastrophic failure. Current conventional backups of master, MSDB and model are available. Full database snapshots and conventional log backups are available for some user databases. The snapshot backups are mounted after recovery of master.

Steps

  • Restore Microsoft® SQL Server™ service. (This may require restore from a file system backup or a reinstall.)

  • Start SQL Server in single user mode (-m).

  • Restore master database.

  • Restart server normally.

    For each selected database {

    Restore database with norecovery.

    Apply log backups and recover.

    }