Disaster Recovery, Master Backup Not Available

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.

  }