SCDPM 2012 SQL Database Migration

February 25, 2014

So I was at a client site that had previously setup DPM and they brought us in to do some Best Practice / Site Evaluation work for them on their System Center Data Protection Manager (SCDPM) installation. They had a single DPM server with SQL installed on the C: drive that they wanted to use to back-up their entire environment. Of course once of their main complaints was the slowness and hanging. I advised them that we would want to setup multiple DPM serves and have a separate SQL DB Server that we could use and expand for the SC suite that they were wanting to eventually migrate to. Since they DID have some data on the old integrated SQSL DB, I needed to save that data and migrate them over to the new SQL Server. Here are the steps that I took to accomplish this task.

1. Create a backup of your DPM-DB (as it is on a remote server do: On the computer where the DPM database is installed, open an elevated command prompt window, type cd <system drive>:\Program Files\Microsoft System Center 2012\DPM\DPM\bin\, and then type DPMBackup.exe -db and press ENTER. ATTENTION in case you are using a named instance and your DPM-DB name is not the default you will have to use -instancename <instance> and -dpmdbname <name> with the dpmbackup command)

Clip Image004 2 313 F6 Bad

Clip Image006 2 313 F6 Bad

2. Copy the backup file to a different location. (You will find the backup at:<system drive>:\Program Files\Microsoft System Center 2012\DPM\DPM\Volumes\ShadowCopy\Database Backups. The file name of the DPM database backup is DPMDB.bak)

Clip Image008 2 313 F6 Bad

3. Uninstall the DPM server - Choose the 2012 - Data Protection Manager and then select Uninstall/Change.

Clip Image010 2 313 F6 Bad

VERY Important!!! Retain data when asked (not a very nice thing to do but the only way I know to change the DPM-DB) 

Clip Image012 2 313 F6 Bad

Clip Image014 2 313 F6 Bad

Clip Image016 2 313 F6 Bad

Clip Image018 2 313 F6 Bad

4. Install the DPM 2012 server and point it to the new SQL-Serve

5. Restore the DPM-DB from your backup (On the computer where your DPM database will be restored, open an elevated command prompt window, type cd <system drive>:\Program Files\Microsoft System Center 2012\DPM\DPM\bin\, and then type DpmSync –restoredb –dbloc <DPMDB file location> and press ENTER.)

6. Now go to command prompt, type DpmSync -sync.

7. Check all protection groups for failed jobs and re-start them and you will have to perform a synchronization for all your data source

After utilizing this guide to moving your SQL database, you find that there is no need to do a reinstall and restore of the database from you DPM environment.  Once the SQL was broken out into a separate server, the performance of the backups increased greatly.  The client was now able to perform backups within the window and did not have an overloaded server to contend with.

Enjoy!


Information and material in our blog posts are provided "as is" with no warranties either expressed or implied. Each post is an individual expression of our Sparkies. Should you identify any such content that is harmful, malicious, sensitive or unnecessary, please contact marketing@sparkhound.com.

Meet Sparkhound

Review our capabilities and services, meet the leadership team, see our valued partnerships, and read about the hardware we've earned.

Learn How We Work

See how our Plan/Build/Run methodology drives real client success, and gain our team's perspectives on timely tech topics.

Engage With Us

Get in touch any of our offices, or checkout our open career positions and consider joining Sparkhound's dynamic team.