Specifications

Figure 56. Contents selection

Click OK to continue.

Restoring System Databases

System databases can only be restored from a backup created in the Microsoft SQL Server

version that the server instance is currently running.

The master database must be accessible to run a Microsoft SQL Server instance and to

restore databases.

If the master database is not accessible, you have to restore the database from a full backup

and rebuild it.

It is necessary to restore the model and msdb databases if:

• the master database must be rebuilt;

• the model and msdb databases are corrupted;

• the model database was modified (it has been deleted and re-created after

rebuilding the master database).

Selecting Filegroups to Restore

By default, filegroups of the selected database will be selected for restore. If you do not

want to restore specific filegroups, uncheck them in the tree in the left pane. Also if all

filegroups are selected, the entire database will be restored.

Please, keep in mind, restoring separate filegroups over an existing database is possible only

if you selected restoring to the point of failure. Other types of filegroups restoration are

valid only for newly created databases

(automatically created during the restoration

process).

To view the information about filegroups in the right pane, select them from the tree.