Recovering a SQL Server Database

  • Article

Applies To: System Center Data Protection Manager 2010

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

  • Recover to any instance of SQL Server. Enables you to recover to any instance of SQL Server that has been preconfigured by your DPM administrator, and then mount the recovered database. This option is recommended when you have transaction logs to be replayed during recovery.

    Note

    • You cannot recover a database to its original location.

    • When recovering to a different instance of SQL Server or to the same instance of SQL Server, make sure that you enter a different database name.

  • Copy to a network folder. Enables you to recover SQL Server databases as files to a network folder.

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

Concepts

Monitoring Recovery Jobs
Performing a Self-Service Recovery
DPM Self-Service Recovery Wizard