Restore data to its original location on the same computer by using the default values in the Restore Options dialog box. You can choose different combinations of restore options to perform different types of restores.
If you perform a restore from the instance level, all databases in that instance are restored in single restore job. If you perform a restore by selecting multiple non-system databases, the non-system databases are restored through multiple jobs.
If you are performing an in-place restore operation and you want to either overwrite an existing database or restore multiple backups of the same database, select the Unconditionally overwrite existing databases or files check box during the restore operation.
Note
A full SQL Server instance restore is not supported when restoring the full instance to a SQL Server instance that is used by the Commvault Commserve.
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 Advanced Restore, then click View Content.
-
Select the data that you want to restore, and click Recover All Selected.
The SQL Restore Options dialog box is displayed.
-
On the General tab, choose how you want to restore the data.
For more information about general restore options, see SQL Restore Options (General).
-
On the Job Initiation tab, choose whether to run the restore job immediately or on a schedule.
-
Optional: To further customize the restore operation, click Advanced.
The Advanced Restore Options dialog box appears.
Goal
Action
Restore transaction marks in the transaction log
On the Options tab, select Transaction Log Marks.
Restore only the last full backup of a database
On the Options tab, select Full Backup Only.
Restore a database with restricted user access
On the Options tab, select Leave Database in Restricted User Mode.
Restore a database without exclusive access
On the Options tab, select Drop Connections to Database.
Restore databases to a disk
On the Options tab, select Restore to Disk.
Restore the IntelliSnap or VSS-enabled backups to disk
On the Options tab, select Restore to Disk, and then select Attach to SQL Server to attach the database files.
Run a restore validation job
On the Options tab, select Verify Only, and then click OK in the Information dialog box.
Run checksum validation during a restore operation
On the Options tab, select Checksum.
Ignore errors encountered during a restore operation and complete the job
On the Options tab, select Continue After Error.
Leave the database in restricted user mode
On the Options tab, select Leave Database in Restricted User Mode.
This option is only available if the bEnableAdvancedRestoreOptionsMSSql setting is set to "true".
Preserve the replication settings
On the Options tab, select Preserve Replication Settings.
This option is only available if the bEnableAdvancedRestoreOptionsMSSql setting is set to "true".
Keep the change data capture
On the Options tab, select Keep Change Data Capture.
This option is only available if the bEnableAdvancedRestoreOptionsMSSql setting is set to "true".
Run a restore-related process before or after a restore operation
Enter the path for the batch file in the Pre Recovery Command box or the Post Recovery Command box. You can also click Browse to select a batch file to run a pre or post restore process.
-
Optional: Run your restore operations from a command line interface. Click Save as Script.
For more information, see Command Line Interface.
-
Click OK.
If you selected to run the restore job immediately, you can monitor the progress of your restore job in the Job Controller window. For more information, see Job Controller.
After the restore job is complete, you can view the restore job history. For more information, see Job History.