Users Guide

NOTE: When restoring a live Hyper-V virtual machine, the following message is displayed in Hyper-V Manager:
The virtual machine [name] has been deleted. Click Exit to exit Virtual Machine Connection.
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 dierential 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) congured the le 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 eld.
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.
42
Backing Up and Restoring Data