Recovering a database to its original location

As part of a recovery process, recovering databases by using DPM is an important task. While the procedure that follows provides the general steps for database recovery, when you recover a CPS feature, you must follow the feature's specific recovery steps as described in the “Recovering from management cluster component failures” section in the CPS Admin Guide.

1. In the DPM administrator console, click Recovery in the navigation bar.

2. In the Recoverable Data area, expand SQL Server, All Protected SQL Instances, expand the instance of SQL Server that hosts the database that you want to recover, and then select the appropriate database, as shown in the following image.

3. In the Recovery Points pane, select a recovery point by clicking any date and time in the calendar to see available recovery points. Dates that are shown in bold have active recovery points. To minimize data loss, it is important to choose to recover from the latest possible recovery point.

4. Click Recover in the Actions pane to launch the Recovery Wizard.

5. In the Recovery Wizard, on the Select Recovery Type page, select Recover To The Original Instance Of SQL Server (Overwrite Database), and then click Next.

6. On the Specify Database State page, keep the default setting of the Leave Database Operational option.

7. On the Specify Recovery Options page, leave the Network Bandwidth Usage Throttling and SAN Recovery settings without any changes.

8. On the Summary page, review your settings, and then click Recover.

9. After the recovery completes, click Close to close the Recovery Wizard.

10. After you recover a database, it must be synchronized by DPM. The protection status of this database will be Replica Inconsistent until you synchronize it as follows:

a. In the DPM administrator console, click Protection in the navigation bar.

b. Right-click the recovered database, and then click Perform Consistency Check.

c. In the Microsoft System Center 2012 R2 Data Protection Manager dialog box, click Yes to perform the consistency check.

Source of Information : Microsoft System Center