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
user-created database to a different location on the same destination server.
1. |
- From the CommCell Browser, navigate to Client Computers |
<Client>
| SQL Server.
- Right-click the instance and then click All Tasks
| Browse
Backup Data.
|
![](../../images/restore/sql/basic_01.gif) |
2. |
Click OK. |
![](../../images/restore/sql/browse_options.gif) |
3. |
- In the right pane of the Browse window, select the database you
want to restore.
- Click Recover All Selected.
|
![](../../images/restore/sql/basic_02.gif) |
4. |
Click Advanced. |
![](../../images/restore/sql/basic_03.gif) |
5. |
- 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.
|
![](../../images/restore/sql/basic_04.gif) |
6. |
Click OK. |
![](../../images/restore/sql/basic_05.gif) |
7. |
You can monitor the progress of the restore job in the Job Controller. |
![](../../images/restore/sql/basic_06.gif) |
8. |
Once the restore job has completed, right-click the
agent and click View | Restore History. |
![](../../images/restore/sql/restore_history_01.gif) |
9. |
Click OK. |
![](../../images/restore/sql/restore_history_02.gif) |
10. |
You can view the following details about the job by right-clicking the
job:
- View Job Path
- Send Logs
- Resubmit Job
|
![](../../images/restore/sql/restore_history_03.gif) |
11. |
Once the database is restored, verify that the
restored database and log files are available in the restore destination provided
during step 5. |
![](../../images/restore/sql/restore_destination_basic.gif) |