You can restore an entire SQL instance, including system databases, to its original location on the computer.
The instance recovery option is the preferred method to restore system databases.
This option restores databases to the same locations from which they were backed up. The data being restored is unconditionally written and overwrites the files of any other databases that are currently using the same database names. The time you specify in the Time tab is used and all connections to the databases are dropped to ensure exclusive access for the restore operation.
Databases which have been removed from the content of any of the SQL instance's subclients cannot be restored.
Procedure
-
From the CommCell Browser, click Client Computers > client > SQL Server.
-
Right-click the instance, and then click All Tasks > Browse and Restore.
-
In the Browse and Restore Options dialog box, click Instance Recovery, then click View Content.
-
In the browse view, all the databases in the instance are selected and cannot be deselected. Click Recover All Selected.
The SQL Restore Options dialog box is displayed, showing information on all the databases in the instance.
-
Click OK. The restore job runs immediately.
