How to Copy a SQL Database to a Network Folder

Applies To: System Center Data Protection Manager 2007

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

In DPM Administrator Console, click Recovery on the navigation bar.
Using the browse functionality, select the database to recover.
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.
On the Recovery time menu, select the recovery point you want to use.
In the Actions pane, click Recover.

The Recovery Wizard starts.
On the Review recovery selection page, click Next.
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.
Specify the destination path to which the database should be copied.
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.
On the Summary page, review the recovery settings, and then click Recover.

See Also