Restoring SQL Databases to Disk

Updated

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 a database restore using SQL Management Studio or any other third-party tools.

The data being restored is unconditionally written and overwrites the files of any other databases that are currently using the same database names or path.

Before You Begin

Verify that the SQL Server Agent is installed on the destination client.

Procedure

  1. From the CommCell Browser, go to Client Computers > client > SQL Server.

  2. Right-click the SQL Server instance, and then go to All Tasks > Browse and Restore.

    The Browse and Restore Options dialog box

  3. Select Restore to disk, and then click View Content.

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

  5. To restore a database to a different destination client, from the Destination Client list, select the destination client.

  6. In the Path box, enter the path or use Browse to browse to the path.

    The chosen path is displayed in the Physical Path column.

  7. Click OK.

    The restore job runs immediately.

Was this page helpful?