Islam Gomaa

Moving DPM Database From Remote SQL to local SQL

The first time I installed DPM 2007 , I thought it is a good idea to Install DPM Database on a dedicated SQL server for performance wise.   well that was a big mistake because if you lose connectivity between the DPM server and SQL server  your backup is not going to run, etc ..

So in order to move the DPM 2007 Database from a SQL server to the DPM server, you need to do the following

• Stop DPM service on the DPM  to guarantee that there is no backup running.
• Backup the DPM Database on SQL server “Full backup bak file”
• Uninstall DPM Server but make sure to choose to retain data
• After rebooting the DPM server, Install DPM  and choose install the database on the local machine.
• Remember to install service pack and any hotfix /patches
• After the installation is successful, stop DPM service.
• Restore the DPM database on the SQL server of the DPM server using DpmSync –RestoreDb –DbLoc location –InstanceName server\instance]
• example

DpmSync –RestoreDb -DbLoc G:\DPM\Backups\2005\November\DPMDB.bak

• After you restore the DPM database, to synchronize the databases, you run the following command on the DPM Server
• DpmSync -Sync
• DpmSync is a  tool to restores the DPM database, synchronizes the DPM database with the replicas in the storage pool, restores the Report database, and reallocates missing replicas.
• DpmSync –RestoreDb –DbLoc location –InstanceName server\instance].

Islam Gomaa

Published Thursday, September 10, 2009 9:01 PM by islam