Getting Started - Microsoft SQL Server Restore

Perform a Restore

As restoring your backup data is very crucial, it is recommended that you perform a restore operation immediately after your first full backup to understand the process.

The following sections explain the steps for restoring a database to a different location on the same destination server.

1.
  • From the CommCell Console, navigate to Policies | Storage Policies.
  • Right-click the <storage policy> and click Properties.
  • Click the Copy Precedence tab.
  • By default, the snapshot copy is set to 1 and is used for the operation.

    You can also use a different copy for performing the operation. For the copy that you want to use, set the copy precedence as 1.

  • Click OK.
2.
  • From the CommCell Browser, navigate to Client Computers | <Client> | SQL Server.
  • Right-click the instance and then click All Tasks | Browse Backup Data.
3. Click OK.
4.
  • Click the instance node in the left pane. Select the database you want to restore in the right pane.
  • Click Recover All Selected.
5. Click Advanced.
6.
  • Click the Options tab.
  • Rename the database name under the Database column.
  • Change the path of the database and log files under the Physical Path column.
  • Click OK.
7.
  • Click the Data Path tab.
  • Select a Windows MediaAgent from the Use MediaAgent drop-down list.
  • Click OK.
8. Click OK.
9. You can monitor the progress of the restore job in the Job Controller.
10. The database and the log files are restored to the location specified in step 6.  

Congratulations - You have successfully completed your first backup and restore.

If you want to further explore this Agent's features read the Advanced sections of this documentation.

If you want to configure another client, go back to Setup Clients.