You can restore the backed up data to a disk on either the same SQL Server or to a different SQL server. This restored data on the disk can be used later to perform database restore using SQL Management studio or any other third party tools.
For Snap/VSS Backups, during restore to disk the actual database files (MDF/LDF/NDF) will be copied to the folder location provided by the user on the destination SQL server machine. In this scenario the database can be restored with different names while physical names should be left intact. All log backups which will be restored as *.bak files cannot be applied to a restored Full backup and can be discarded. This option is applicable for VSS and SNAP backups performed using Commvault 10.0 or higher.
VSS and block-level backups can be restored to a different SQL server.
Note
The Restore To Disk option, overrides all other SQL Server Restore options.
Procedure
-
From the CommCell Browser, expand 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 View Content.
-
In the Browse view, select the data that you want to restore, and click Recover All Selected.
The Restore Options dialog box appears.
-
If you plan to restore without a destination server, on the General tab, leave the Destination Server box blank.
-
Select the Restore To Disk check box.
-
In the Path box, type the path where you want to restore to disk on the client computer.
-
Select the Unconditionally overwrite existing database or files check box.
-
If you chose a destination server during the restore, complete the following steps:
-
Click Advanced.
The Advanced SQL Restore Options dialog box appears.
-
For Snap/VSS Backups, if needed, on the Options tab,select Attach to SQL Server, and then click OK.
This option attaches the database files (MDF/LDF/NDF), that were restored to the selected SQL server.
-
-
Click OK.