Previous Topic: Verify that the Microsoft Exchange Application was RestoredNext Topic: Review the Restore Prerequisites and Considerations


How to Restore a Microsoft SQL Server Application

CA ARCserve D2D allows you to not only protect and recover your data, but also helps you to get the applications that will use that data back up and running. All application recoveries can only be made using the Restore by Recovery Point method. During an application recovery, CA ARCserve D2D takes advantage of Windows Volume Shadow Copy Service (VSS) to help ensure data consistency for any VSS-aware application. With CA ARCserve D2D, you can recover the Microsoft SQL Server application without performing a full disaster recovery.

The following diagram illustrates the process to restore a Microsoft SQL Server Application:

This diagram indicates the process to restore an MS SQL Server application

Perform the following tasks to restore a Microsoft SQL Server Application:

  1. Review the Restore Prerequisites and Considerations
  2. Specify the Microsoft SQL Server Information to Restore
    1. Specify the Recovery Point and Microsoft SQL Server Database
    2. Define the Restore Options
  3. Restore the Microsoft SQL Server Application
  4. Verify that the Microsoft SQL Server Application was Restored

SUPPLEMENTAL VIDEO

This procedure contains a supplemental instructional video. Select either CA Support or YouTube as the source for viewing this video. The versions of the video from CA Support and YouTube are identical, and only the viewing source is different.

Video

CA Support:

How to Restore a Microsoft SQL Server Application

YouTube:

How to Restore a Microsoft SQL Server Application