Restoring your data > Restore Data Protection Manager (DPM) > Recover a DPM SQL Database

Recover a Microsoft DPM SQL Database

If your DPM server has failed, use the following procedure to recover the DPM server.

If your server is working, and you only need to recover DPM data sources or the DPM database, see Recover DPM data sources and Reconcile a restored SQL DB in a changed DPM environment.

Suspend Backups

To ensure that the Server Vaulting service is not backing up while you are recovering your DPM server, you must suspend backups.

To suspend backups

  1. Log into the Cloud Direct Server Vaulting Management Portal Web UI.

  2. In the left pane of the Web UI, select the server.

  3. Click Properties.

    The Computer Properties page opens.

  4. Click Edit Properties.

    The Edit Computer Properties page opens.

  5. Select Suspend Backup.

  6. Click Save.

    Backup is suspended for the selected server.

Remove the DPM Application from the Server

After backup is suspended, you must remove the DPM application from the server.

To remove DPM from the server

  1. At the DPM server, go to the Add/Remove programs control panel, and remove Microsoft System Center Data Protection Manager.

  2. Restart the server.

  3. Open SQL Server Management Studio and delete the DPM database.

Reinstall DPM 2010 or DPM 2007 SP1

Reinstall the DPM 2010 or DPM SP1 application.

To install DPM 2010 or DPM 2007 SP1

  1. Install the selected DPM version:

    DPM 2010

    DPM 2007 SP1

  2. Restart the server.

Restore the DPM SQL Database

After you complete the installation of the DPM application, you use Server Vaulting to restore the DPM SQL Database.

To restore the DPM SQL Database

  1. Log into the Cloud Direct Server Vaulting Management Portal Web UI.

  2. Select the DPM computer.

    The Computer summary page opens.

  3. Click the Restore tab.

    The Restore summary page opens.

  4. Click New Restore.

    The Restore wizard opens.

  5. Select one of the following options:

  6. Click Next.

    The page opens.

  7. Select DPM SQL Database policy restore.

  8. Click Next.

    The page opens.

  9. Type a name for the restore.

  10. Specify the version to restore. By default, the most recent version is restored.

  11. Click the Options tab.

    The Restore Options page opens.

  12. Select Redirect restored files to a different location.

  13. Select Don't preserve directories.

  14. Specify the path to a location where you want to restore the database file, for example C:\RestoredDB.

  15. Click Done.

    The restore is submitted. Wait for the restore job to complete.

Synch the Restored Database with DPM Management Shell

Once the Server Vaulting restore is complete, you must synchronize the restored database in DPM.

To synch the restored database

  1. Open the DPM Management shell and follow the steps below:
     

    1. In the DPM Management shell, type the following command:

      Run DpmSync.exe -RestoreDb -DbLoc [fully qualified path to the database you restored in step 4]

      For example:

      DpmSync.exe -RestoreDb -DbLoc C:\RestoredDB\DPMDB2007RTM.mdf
       
    2. In the DPM Management shell, run the following command:

      Run DPMSync.exe –sync
       
  2. On the DPM server, open the DPM Administrator Console and perform a consistency check.
    1. On the Protection tab, right-click the protected data sources.

    2. Select Perform consistency check...

      You do not need to wait for the consistency check to complete before performing the next step.

Enable Backups

To enable backups on the recovered DPM server.

  1. Log into the Cloud Direct Server Vaulting Management Portal Web UI.

  2. In the left pane of the Web UI, select the server.

  3. Click Properties.

    The Computer Properties page opens.

  4. Click Edit Properties.

    The Edit Computer Properties page opens.

  5. Select Enable Backups.

  6. Click Save.

    Backup is enabled for the selected server.

 


© 2018 j2 Global, Inc. and affiliates. All rights reserved. LiveVault® is a registered trademark of KeepItSafe, Inc.