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 instance is restored from the backup that you specify under Recovery Points 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.
Note
Full Instance restores to the SQL instances used by the Commvault software on the Commserve and the Web Server are not supported.
Procedure
-
From the navigation pane, go to Protect > Databases.
The Overview page appears.
-
On the Instances tab, click the SQL instance that you want to restore.
-
In the upper-right corner of the page, click
, and then select Instance Recovery. -
In the message that appears confirming if you want to proceed with the recovery operation, click Yes.
Note
The SQL server service will be restarted during master DB restore.