Modify the SQL Server database used by DPM


Updated: May 13, 2016

Applies To: System Center 2012 SP1 - Data Protection Manager, System Center 2012 - Data Protection Manager, System Center 2012 R2 Data Protection Manager

System Center 2012 – Data Protection Manager (DPM) requires a dedicated instance of 64-bit SQL Server for its database, which you specify during installation. If you want to modify the SQL Server instance following installation, you’ll need to uninstall and reinstall DPM as follows:

  1. Ensure that you have a recent backup of the DPM database (DPMDB).

  2. Uninstall DPM and choose to retain data.

  3. Install DPM and specify a new instance of SQL Server. For more information, see Installing DPM.

  4. Restore DPMDB to the new instance of SQL Server, run DpmSync, and then run a consistency check for the data sources protected by the DPM server.