Restore and Recover Virtual Machines › Application Level Restores › Restore SQL Server Data

Restore SQL Server Data

You can perform application level restores of Microsoft SQL Server data with the following:

• Microsoft SQL Server 2005 Express, Standard, Workgroup, and Enterprise
• Microsoft SQL Server 2008, SQL Server 2008 R2 Express, Web, Standard, Workgroup, and Enterprise

Note: Before you begin, read the prerequisites in Application Level Restores.

Important! Microsoft SQL Server granular restore is not supported from CA ARCserve Central Host-Based VM Backup backup sessions. To restore Microsoft SQL Server data at a granular level, back up the SQL Server data using CA ARCserve Central Protection Manager or CA ARCserve D2D.

To restore SQL Server data

1. Verify that CA ARCserve D2D is installed on the guest operating system.
2. Log in to the guest operating system for the virtual machine where you want to restore Exchange Server data.
3. Start CA ARCserve D2D and then click Restore on the CA ARCserve D2D Navigation panel to open the Restore dialog.
4. Click Browse Recovery Points to open the Browse Recovery Points dialog.
5. In the Specify backup location field on the Browse Recovery Points dialog, specify the path to the backup session on the Host-Based VM Backup virtual machine that you want to restore Exchange Server data from. The following path is an example of the path to the backup session on the Host-Based VM Backup virtual machine:

   https://<server name>/<share name>/vm@<host name or IP address of the ESX Server system>
   

6. Select the recovery point (date and time) and then select the Microsoft SQL Server database to be restored.

   

7. Click Next to open the Restore Options dialog.

   Select the destination for the restore. The available options are to restore to the original location of the backup, restore the dump file only, or restore to an alternate location.

   Restore to original location

   Restores to the original location from where the backup image was captured.

   Dump file only

   Restores the dump files only.

   Dump files are created when an application crashes and contains additional (time-stamped) information that can be used to troubleshoot the cause of the problem.

   When you select this option, you can then specify or browse to the folder location where the dump file will be restored to.

   

   Restore to alternate location

   Restores to an alternate location (not the original location).

   

   Because backups can be copied to network locations, they can be used by multiple SQL Server instances. Multiple database restore can be performed (simultaneously) from the instance level. From this listing, you can select the database instance and specify a new database name and alternate location to restore the database to. In addition, you can also browse to the alternate location where the database will be restored to.

   

8. Click Next to open the Restore Summary dialog.
9. Review the displayed information to verify that all the restore options and settings are correct.
   • If the summary information is not correct, click Previous and go back to the applicable dialog to change the incorrect setting.
   • If the summary information is correct, click Finish to launch the restore process.