Administrator Guide

Table Of Contents
7. Select Do Not Recover Databases.
8. Review the restore point details, and click Restore.
Rename and Restore SQL Server Components Stored on a Volume
Use the Restore Snapshot dialog box to rename and restore SQL Server components on a volume.
1. In the Server Connections area of the navigation pane, connect to a server or host.
2. In the Backup Extensions area of the navigation pane, select the SQL Server Databases backup extension.
3. In the left side of the explorer pane, select a component. Restore points for the component are displayed in the right side of
the explorer.
4. Select a restore point.
5. In the Restore Points area of the action pane, click Restore.
The Restore Snapshot dialog box opens.
6. Click
in the row containing the database to be renamed and relocated. The Rename Database dialog box opens.
Depending on how the Database Administrator (DBA) configured the file groups for the database, the mdf and ldf may share
the same location or (more commonly) be split between multiple server locations resulting in multiple rows.
7. Enter a new name in the New Database Name field.
A database must be relocated to be renamed.
8. Enter a new path in the New Path column of each appearing row.
The new path cannot be the same as the current path and must be able to be created on the target system.
When adding a new path, the complete path (drive letter and all subdirectories) must be entered. For example, if the new
path is the SQL2 directory on the I: drive, then I:\SQL2 is entered. If the new path is the SQL2\Data directory on the I:
drive, then I:\SQL2\Data is entered.
9. Click OK.
10. The Restore Snapshot dialog box now displays the new database name.
The name or path can be changed by clicking
again.
Or click
and delete the new name to cancel the name change.
11. To begin the restore, click Restore.
File names are not changed when the database is renamed.
Rename and Restore SQL Server Components Stored on an SMB
File Share
Use the Restore Snapshot dialog box to rename and restore SQL Server components on an SMB file share.
1. In the Server Connections area of the navigation pane, connect to a server or host.
2. In the Backup Extensions area of the navigation pane, select the SQL Server Databases backup extension.
3. In the left side of the explorer pane, select a component. Restore points for the component are displayed in the right side of
the explorer.
4. Select a restore point.
5. In the Restore Points area of the action pane, click Restore. The Restore Snapshot dialog box opens.
6. Click
in the row containing the database to be renamed and relocated. The Rename Database dialog box opens.
Depending on how the Database Administrator (DBA) configured the file groups for the database, the mdf and ldf may share
the same location or (more commonly) be split between multiple server locations resulting in multiple rows.
7. Enter a new name in the New Database Name field.
8. Enter a new path in the New Path column of each appearing row.
The new path must be within the original SMB file share and must be able to be created on the target system.
For FILESTREAM data only, omit the last subdirectory from the path.
9. Click OK.
10. The Restore Snapshot dialog box now displays the new database name.
The name or path can be changed by clicking
again.
Backing Up and Restoring Data
39