You can use the Commvault Plug-in for SQL Management Studio to restore the latest backup cycle of a single, selected database.
Note
Not all advanced restore options are available when restoring the latest backup cycle of a single, selected database. For example, options like Step Restore, Transaction Log Marks and Partial Restore are not available.
Procedure
-
Open SQL Management Studio.
-
In Object Explorer, right-click the database that you want to restore, and then click Data Protection Tasks > Restore > Current Database.
-
If you are performing the restore operation for the first time after opening the SQL Management Studio, you are prompted for credentials.
Enter your user name and password to log on to the CommServe. The user must have view permissions on the client to perform the restore operation.
-
In the Restore Screen dialog box, choose how you want to restore the data.
For more information about general restore options, see SQL Restore Options (General).
-
Optional: Further customize the restore operation. Click the Advanced tab to set up the restore operation.
For more information about the Advanced Options, see Advanced Restore Options.
-
Click Restore.
While the restore job is running, you can monitor the restore job progress.