Export (0) Print
Expand All

How to Recover a SQL Database to Its Original Location

Updated: November 1, 2013

Applies To: System Center 2012 - Data Protection Manager, System Center 2012 R2 Data Protection Manager, System Center 2012 SP1 - Data Protection Manager

To recover a database to its original location

  1. In DPM Administrator Console, click Recovery on the navigation bar.

  2. Using the browse functionality, select the database to recover.

  3. On the calendar, click any date in bold to obtain the recovery points available for that date. The Recovery time menu lists the time for each available recovery point.

  4. On the Recovery time menu, select the recovery point you want to use.

  5. In the Actions pane, click Recover.

    The Recovery Wizard starts.

  6. On the Review recovery selection page, click Next.

  7. Select Recover to original SQL Server location, and then click Next.

  8. If you selected a recovery point other than Latest, on the Specify Database State page, select Leave database operational.

  9. Specify recovery options for network bandwidth usage throttling, SAN-based recovery, and e-mail notifications, and then click Next.

  10. On the Summary page, review the recovery settings, and then click Recover.

See Also

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft