Using CA ARCserve D2D › Application Restore › Application Restore - MS SQL Server

Application Restore - MS SQL Server

CA ARCserve D2D allows you to not only protect and recover your data, but also helps you to get the Microsoft SQL Server application that will use that data back up and running. The Microsoft SQL Server recovery can only be made using the Restore by Recovery Point method.

Restore Microsoft SQL Server Application

1. From the CA ARCserve D2D home page (or CA ARCserve D2D Monitor), select Restore.

   The restore methods selection dialog opens.

2. Click the Browse Recovery Points option.

   The Browse Recovery Points dialog opens.

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

   The corresponding marker box becomes filled (green) to indicate that the database has been selected for the restore. You can select a single or multiple databases to be restored.

   

4. Click Next.

   The Restore Options dialog opens.

   

5. 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.

     Note: When restoring the CA ARCserve D2D logs folder to the original location, the files that are in the logs folder will be skipped.

   • 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 be restored to.

   

6. Click Next.

   The Restore Summary dialog opens.

7. 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.