Modifying the SQL Server database used by DPM
Updated: November 1, 2013
Applies To: System Center 2012 - Data Protection Manager, System Center 2012 R2 Data Protection Manager, System Center 2012 SP1 - Data Protection Manager
System Center 2012 – Data Protection Manager (DPM) requires a dedicated instance of 64-bit SQL Server for its database. For detailed database requirements, see System Requirements for DPM in System Center 2012.
You specify the SQL Server instance you want to use during DPM installation. If you want to modify the SQL Server instance used by DPM following installation, you’ll need to uninstall and reinstall DPM as follows:
Ensure that you have a recent backup of the DPM database (DPMDB).
Uninstall DPM and choose to retain data.
Install DPM and specify a new instance of SQL Server. For more information, see Installing DPM.
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 additional resources, see Information and Support for System Center 2012.
Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.