Recovering System Databases

Recovering system databases

 

All system databases of an instance are recovered at once. When recovering system databases, the software automatically restarts the destination instance in the single-user mode. After the recovery completes, the software restarts the instance and recovers other databases (if any).

Other things to consider when recovering system databases:

 

  • System databases can only be recovered to an instance of the same version as the original instance.
  • System databases are always recovered in the "ready to use" state.

 

Recovering the master database

System databases include the master database. The master database records information about all databases of the instance. Hence, the master database in a backup contains information about databases which existed in the instance at the time of the backup. After recovering the master database, you may need to do the following:
  • Databases that have appeared in the instance after the backup was done are not visible by the instance. To bring these databases back to production, attach them to the instance manually by using SQL Server Management Studio.
  • Databases that have been deleted after the backup was done are displayed as offline in the instance. Delete these databases by using SQL Server Management Studio.
  • 4 Users Found This Useful
Was this answer helpful?

Related Articles

File Filters

File filters File filters define which files and folders to skip during the backup process....

Operations with Backup Plans

Operations with backup plans   To edit a backup plan   1. If you want to edit the backup plan...

Downloading Files from the Cloud Storage

Downloading files from the cloud storage You can browse the cloud storage, view the contents...

File-level Backups

File-level backups   The scheduling parameters of a file-level backup depend on the backup...

Selecting SQL databases

Selecting SQL databases A backup of an SQL database contains the database files (.mdf, .ndf),...