Administrator Guide

During a restore operation, the Hyper-V VSS writer deletes virtual machines before restoring them. This message does not indicate a

problem. Click Exit to acknowledge the message.

Restore SQL Server Components without Recovering the

Database

Use the Do Not Recover Databases option if you want to apply transaction logs or differential backups to the restored database.

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. 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. In the Components area, select or clear the check boxes next to the components to choose which components to restore.

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.

Backing Up and Restoring Data