The DPM Self-Service Recovery Tool (SSRT) offers you the following options for recovering a SQL Server database:

To recover a SQL Server database to any instance of SQL Server

  1. In the DPM SSRT Console, click New Recovery Job to start the Recovery Wizard.

  2. Select the SQL Server Instance Name and the Database Name that you want to recover, and then click Next.

  3. Available recovery points are indicated in bold on the calendar in the recovery points section. Select the date from the calendar and the time from the drop-down list for the recovery points that you want to recover, and then click Next.

  4. Select Recover to any instance of SQL Server. This option enables you to recover to any instance of SQL Server which is preconfigured by your DPM administrator.

  5. Click Next. Select the SQL Server Instance Name.

  6. Select the Database file location. You can either select a folder path that is preconfigured by your DPM administrator or select a custom path for the selected instance of SQL Server.

    • Folder path that is preconfigured by your DPM administrator. The database files will always be recovered to a new folder that is created during recovery under the folder path that is preconfigured by your DPM administrator.


    • Custom path. If you select custom path, then in the Database file locations section, under the Database file location column, you can specify a folder path for each database file.


      Note
      The custom path option will be available only if your DPM administrator has configured this option for you on the DPM server.
  7. Specify the Recovered Database Name, and then click Next.

  8. Specify the database state and then click Next.

  9. Select the Send an e-mail when this recovery completes check box to notify you when the recovery job is completed. Specify the recovery options and then click Next.

    Note
    The check box is enabled only if your DPM administrator had configured e-mail notifications on the DPM server.
  10. On the Summary page, review the recovery settings, and then click Recover.

To copy a SQL Server database to a network folder

  1. In the DPM SSRT Console, click New Recovery Job to start the Recovery Wizard.

  2. Select the SQL Server Instance Name and the Database Name that you want to recover, and then click Next.

  3. Available recovery points are indicated in bold on the calendar in the recovery points section. Select the date from the calendar and the time from the drop-down list for the recovery points that you want to recover, and then click Next.

  4. Select Copy to a network folder. This option enables you to recover SQL databases as files to a network folder. Specify the name of the destination server and destination folder path. Click Next.

    Note
    If the recovery point that you selected was not created from an express full backup, you will be presented with new recovery point choices. DPM can only copy files from a recovery point that is associated with an express full backup. Select an alternate recovery point and then click Next.
  5. Select the Send an e-mail when this recovery completes check box to notify you when the recovery job is completed. Specify the recovery options and then click Next.

    Note
    The check box is enabled only if your DPM administrator had configured e-mail notifications on the DPM server.
  6. On the Summary page, review the recovery settings, and then click Recover.

See Also