You can restore 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 the restore to disk the actual database files (MDF/LDF/NDF) are 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 the physical names must 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.
Before You Begin
Verify that the SQL Server Agent is installed on the destination client.
Procedure
-
From the CommCell Browser, go to Client Computers > client > SQL Server.
-
Right-click the SQL Server instance, and then go to All Tasks > Browse and Restore.
The Browse and Restore Options dialog appears.
-
On the SQL Server tab, click Restore to Disk, and then click View Content.
-
In the browse view, select the data that you want to restore, and then click Recover All Selected.
The SQL Restore Options dialog box appears.
-
From the Destination Client list, select a client computer.
The destination SQL server should be the same or a higher SQL Server version than that of the source SQL server.
-
In the Path box, type the path location on the destination client computer, where you want to restore.
-
To change the database name or the physical path of the database files, click and edit the corresponding Database name or the Physical Path.
-
Click OK.