How to create a manual copy of the DPM database

Share this:

DPM is a great product to protect Microsoft workloads, and now that we can use Azure as long-term repository, to protect the vast majority of workloads (such as Exchange for example). There is one little detail that we must pay attention which is the protection of DPM database (which is on SQL Server), and without it we can’t do much with our protected data in case of a major failure of DPM.

Solution


There are several (no kidding, at least 5 different ways) to protect the DPM database, and in this Tutorial we are going go to use the built-in utility called dpmbackup.

In order to protect the DPM database we should know the SQLServerName, InstanceName and DPM Database Name. Since SQL and DPm can be installed in different ways, such as SQL and DPM, DPM and remote SQL, DPM and Remote SQL Cluster and so forth. We will assume that we have the DPM and SQL installed on the same server.

dpmbackup.exe –db –sqlServerName . –instanceName <SQL-Instance> –dpmdbname DPMDB_<DPM-Server-Name>

Note: By default the dpmdbname is always DPMDB_ plus the DPM Server name.

image[2]

After getting a message Backup  created successfully then we can check a .bak file on the DPM installation folder under DPM\Volumes\ShadowCopy\Database Backups location.

image[5]

Using this procedure one can easily protect their DPM database, but make sure that you move that folder to a different location and in a secure place.

Written by Anderson Patricio

Anderson Patricio

Anderson Patricio is a Canadian MVP in Cloud and Datacenter Management, and Office Server and Services, besides the Microsoft Award he also holds a Solutions Master (MCSM) in Exchange and several other certifications. Anderson has been contributing to the Microsoft Community with articles, tutorials, blog posts, twitter, forums and book reviews. He is a regular contributor here at ITPROCentral.com, MSExchange.org, Techgenix.com and Anderson Patricio.org (Portuguese).

Related Post

Using DPM to create a Recovery Point in Microsoft ... Using DPM (Data Protection Manager) an administrator is able to create a Recovery Point directly on Backup Vault/Microsoft Azure, and that is going to...
How to disconnect media on all VMs in SCVMM 2008 R... Hello folks, Today I had a requirement to disable configure all VMs of a SCVMM 2008 R2 to  No Media and I could’ve gone to each one of the VMs, ask P...
DPM 2012 R2–ID 30146 unkown error protecting... How to solve the ID 30146 Details: Unknown error (0xc0000135) error when protecting Exchange or SharePoing when using DPM Server 2012 or 2012 R2. Sol...
Virtualizing Your Data Center with Hyper-V and Sys... Free online event with live Q&A: http://aka.ms/virtDC Wednesday, February 19th from 9am – 5pm PST If you're new to virtualization, or if you hav...