Export (0) Print
Expand All

How to Copy a SQL Database to a Network Folder

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

You can only copy a SQL Server database from a recovery point that was created from an express full backup.

To copy a database to a network folder

  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 Copy to a network folder, and then click Next.

    If the recovery point that you selected was not created from an express full backup, you will be presented with new recovery point choices.

  8. Specify the destination path to which the database should be copied.

  9. On the Specify recovery options page, you can select either or both of the following options:

    • Restore security

      Specify whether to use the security settings of the data being recovered or the security settings of the target destination.

    • Send an e-mail when this recovery completes.

      Select this option to specify an e-mail address or addresses to notify upon recovery completion. If you select this option, you must enter the e-mail address to notify. Multiple e-mail addresses must be separated by a comma.

  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
© 2014 Microsoft