Administrator Guide

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

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.

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