Changing the SQL Server Instance Used by DPM

  • Article

Applies To: System Center Data Protection Manager 2010

DPM uses a specified instance of SQL Server to stores its database. You specify the instance of SQL Server that DPM will use during the DPM installation process. It is possible to change the instance of SQL Server that a DPM server uses only by uninstalling and reinstalling DPM.

If you need to change the instance of SQL Server for a DPM server, use the following process:

  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 2010 (https://go.microsoft.com/fwlink/?LinkID=179156) in the DPM Deployment Guide.

  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.

This process depends on the availability of a backup of the DPM database. For more information about backing up and restoring the DPM database, see Setting Up Disaster Recovery.

See Also

Concepts

Performing DPM Server Management Tasks