How to Recover DPM Databases
Applies To: System Center Data Protection Manager 2007
When recovering the DPM database files, ensure that the location on the DPM computer where you restore the files is secure.
To recover the DPM database when the database is corrupt
Uninstall Microsoft System Center Data Protection Manager 2007 through the Add/Remove Programs applet in Control Panel.
Important
Remember to select Retain disk-based recovery points.
Restart the computer.
Delete the DPM database using SQL Server Management Studio.
Install DPM 2007.
Restart the computer.
On the DPM server, create a folder to which you can restore the files.
Insert the tape with the latest backup of DPMDB into the tape library.
Open the Libraries tab on the Management tab of DPM Administrator Console.
Click Rescan on the Actions pane.
Go to Updating Tape Library Information for more information on using the Rescan option.
Insert the tape with the latest DPMDB backup in the tape drive/library. You can find the tape having the latest DPMDB backup using the last tape management report.
Select the library from the list and click Inventory libraries… and perform a detailed inventory from the Actions pane.
Select the imported tape from the list and click Recatalog imported tape on the Actions pane.
Open the Recovery tab from DPM Administrator Console.
Select the DPMDB by expanding the External Tapes node.
Click Recover on the Actions pane.
Using the Recovery wizard, recover the database to a network folder. This folder will be the recovery folder you created in Step 6.
Go to How to Inventory Tapes for more information on the procedure to inventory tapes.
Use DPMSync to attach the database to DPM.
DPMSync –RestoreDB –DBLoc location of folder created in Step 6\name of DPMDB
DPMSync takes the DPM service offline and attaches the backed up database to SQL Server.
Go to Using DPMSync for more information.
Run DpmSync -sync