Replay Manager Version 7.7 Administrator’s Guide

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 appears.
6. Click in the row containing the database to be renamed and relocated. The Rename Database dialog box appears.
   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.