Modify the SQL Server database used by DPM
Updated: March 12, 2014
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, 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:
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.
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.