Changing the SQL Server Instance Used by DPM

Applies To: System Center Data Protection Manager 2007

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 choose a new instance of SQL Server. For more information, see Installing DPM (https://go.microsoft.com/fwlink/?LinkId=91851).

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

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

See Also

Concepts

Performing DPM Server Management Tasks

Other Resources

Installing DPM