Restoring the Backed Up Databases from SQL Management Studio

You can use the Commvault Plug-in for SQL Management Studio to browse and restore one or more SQL databases for a selected instance.

Procedure

1. Open SQL Management Studio.

2. In Object Explorer, right-click a database, and then click Data Protection Tasks > Restore > Browse Backup Data.

   If you are performing the restore operation for the first time after opening the SQL Management Studio, you are prompted for credentials.

3. 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.

4. In the Browse Data dialog box, select one or more databases that you want to restore and click Recover Selected.

5. 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).

6. 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.

7. Click Restore.

While the restore job is running, you can monitor the restore job progress.