CA ARCserve D2D Procedures › 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 uses 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 database 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.

   Note: When restoring a Microsoft SQL Server 2012 database that is part of an AlwaysOn Availability Group (AAG), there are some considerations that you should be aware of. For more information, see MS SQL Server 2012 AAG Restore Considerations.

   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.

   When restoring a Microsoft SQL Server application to an alternate location, there are some considerations that you should be aware of. For more information, see MS SQL Server Restore to Alternate Location Considerations.

   

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.