Back up the DPM server

To ensure that data can be recovered if System Center Data Protection Manager (DPM) fails, you'll need a strategy for backing up the DPM server. If it isn't backed up, you'll need to rebuild it manually after a failure, and disk-based recovery points won't be recoverable. You can back up DPM servers using a couple of methods:

• Back up the DPM server - You can back up a primary DPM server with a secondary DPM server. The secondary server will protect the primary server database and the data source replicas stored on the primary server. If the primary server fails, the secondary server can continue to protect workloads that are protected by the primary server, until the primary server is available again. If you need to rebuild the primary server, you can restore the databases and replicas to it from the secondary server. You can also restore data to protected computers directly from the secondary server when the primary server isn't available. You can set up two servers, one as primary and another as secondary, or configure each server to act as the primary for the other. You can also configure a chain of DPM servers that protect each other according to the chain order.

• Back up the DPM database - You can configure a DPM server to back up its own databases to its tape library, or you can use non-Microsoft software to back up the databases to tape or removable media.

• Back up DPM using third-party software - You can back up DPM servers using third-party software that supports DPM and VSS.

Back up with a secondary DPM server

Information on a DPM server can be backed up and protected by another DPM server in any of the following configurations:

• Primary to secondary protection - The database and replicas stored on a primary DPM server can be backed up to a secondary DPM server. If the primary server fails, the secondary server continues to back up protected workloads. If the primary server fails, you can do either of the following: Rebuild the primary server and restore its database and replicas from the secondary server. Then move the protected workloads back to the primary server after the rebuild. Select to switch protection to the secondary DPM server. With this setting, you can then restore to the protected computer directly from the secondary server when the need arises. For instructions, see Set up secondary servers.

• DPM chaining - A chain of DPM servers provide protection, and each server protects the next one in the chain. For example: DPM1 is protected by DPM2 (DPM1 is the primary and DPM2 is the secondary). DPM2 is protected by DPM3 (DPM2 is the primary and DPM3 is the secondary) For instructions, see Set up chaining.

• Cyclic protection - One DPM server is backed up by another DPM server and vice versa. For example, if DPM1 protects DPM2, then DPM2 protects DPM1. This is useful for small environments.

Set up primary and secondary protection

Back up a primary DPM server using a secondary DPM server:

1. The Primary DPM server has the protection agent already installed. You need to attach this protection agent to the secondary DPM server.

   Important

   Major and minor versions of the Primary and Secondary DPM servers must match.

   Follow these steps to attach the agent:

   1. In the DPM Administrator Console of the secondary DPM server, on the navigation bar, select Management > Agents. In the Actions pane, select Install.
   2. On the Select Agent Deployment Method page, select Attach agents > Computer on a trusted domain > Next. The Protection Agent Installation Wizard opens.
   3. On the Select Computers page, DPM displays a list of available computers. Select the name of the Primary DPM server from the Computer name list > Add > Next.
   4. On the Enter Credentials page, type the user name and password for a domain account that is a member of the local Administrators group on the Primary DPM server.
   5. On the Summary page, select Attach.

2. Add the primary DPM server to an existing protection group, or create a new one. Select to protect the following data sources:

   • The SQL Server databases configured for the primary server.

   • All volumes on the primary DPM server (Shares won't be visible separately).

   • All replicas on the primary DPM server.

   • At a minimum, you should select the databases, the \Program Files\Microsoft System Center\DPM\DPM\Config folder, and the \Program Files\Microsoft System Center\DPM\Scripting folder.

Note

You can't exclude file names from protection for a replica. In addition, all DPM servers must be running the same version, updates, etc. When setting up synchronization, we recommend you synchronize every 24 hours.

Set up DPM chaining

Before you consider chaining, remember these limitations:

• Each DPM server can only be protected once in the chain, so verify that they're not protected by more than one server.

• Primary and secondary servers are established by the chain. For example, if server DPM3 is actually protecting server DPM1 because it's acting as the secondary server for DPM2, it can't act directly as a secondary server for DPM1.

• If a DPM server is configured to protect its own data source, the chain will be broken. For example, if DPM1 protects its own database or system state, DPM2 can't protect DPM1.

• Before you can protect the database of a primary DPM server, you need to start the SQL Server VSS Writer service on the primary server.

Chaining example 1

Scenario 1: Chained protection

Scenario 1 shows a scenario in which four DPM servers are chained:

Server	Protecting	Protected by
DS1 (primary)	PS1, PS2	DS3
DS2 (primary)	PS3, PS4	DS3
DS3 (secondary)	DS1, DS2	DS4
DS4 (secondary)	DS3	-

Chaining example 2

Scenario 2: Chained protection

Scenario 2 shows a scenario in which four DPM servers are chained:

Server	Protecting	Protected by
DS1 (primary)	PS1, PS2	DS2
DS2 (primary)	PS3	DS3
DS2 (secondary)	DS1	DS3
DS3 (primary)	PS4	DS4
DS3 (secondary)	DS2	DS4
DS4	DS3	-

Cyclic protection

If you don't want to use a secondary server, then two DPM servers can protect each other.

Scenario 3: Cyclic protection

Scenario 3 shows a scenario using cyclic protection.

Server	Protecting	Protected by
DS1 (primary)	PS1, PS2	DS2
DS2 (primary)	PS3	DS3
DS2 (secondary)	DS1, DS3	DS3
DS3 (primary)	PS4	DS2
DS3 (secondary)	DS2	DS2

Configure chaining

Set up chaining as follows:

1. Install the DPM protection agent on the DPM server that you want to protect from the DPM server you want to protect it from.

2. Configure secondary protection for the data sources protected by the DPM server you're protecting.

Note

In the DPM console, you won't be able to configure protection for data sources that are already protected by the agent. This prevents you from repeatedly protecting data.

3. As an example, if you have DPM1 and DPM2, you'd install the DPM protection agent from DPM1 to DPM2 and vice versa. Then configure secondary protection on DPM2 for servers that DPM1 protects and configure secondary protection on DPM1 for servers that DPM2 protects.

Recover the server

If a primary server fails, you can switch protection to the secondary server. After switching, you can perform recovery functions from the secondary server.

Switch protection to the secondary server

Use the following steps:

1. On the secondary DPM server, in the Protection area of the DPM Administrator console, go to the Protection work area, right-click the data source for which you want to switch protection.
2. Select Switch Disaster Protection from the context menu.
3. Run a consistency check.

After switching protection, the replica appears as inconsistent, until the check runs.

Example:

Note

• To switch the protection back to the primary server, do the same steps as above.
• You can also switch protection to the secondary DPM server by using the Start –DPMSwitchProtection PowerShell cmdlet.

Recover a primary DPM server

When you recover a primary DPM server, you’ll need to re-establish the protection for the computers that were previously protected by the primary DPM server.

Note

• You can’t restore recovery points for data sources protected by the primary DPM server.
• When you recover the database files, ensure that the restore location on the primary DPM server is secure.

Re-establish protection with primary DPM server

1. On the protected computer, from the command prompt, run the command Setdpmserver.exe <primary DPM server name>.

2. Open Computer Management and do the following:

   • Select Local Users and Groups. Verify that the primary server, in the format of Domain/Name, is a member of the following groups:
     • Distribute COM Users
     • DPMRADCOMTrustedMachines
     • DPMRADmTrustedMachines
   • If the primary server isn’t listed in any of the groups, manually add the server in the format of Domain/Name.

If protection fails after completing the above steps, do the following:

1. In Administrative Tools, open Component Services. Expand Computers, expand My Computer, and then select DCOM Config.
2. In the results pane, right-click DPM RA Service. Select Properties > Security.
3. In the Launch and Activation Permissions area, select Edit.
   • If the primary server is listed, the Access Control List (ACL) entry might be incorrect. Remove the entry, and then add the primary server with full permissions.
   • If the primary server isn't listed, add the primary server with full permissions.

Back up the DPM database

As part of your DPM backup strategy, you'll have to back up the DPM database. The DPM database is named DPMDB. This database contains the DPM configuration together with data about DPM's backups. In case of a disaster, you can rebuild most of the functionality of a DPM server by using a recent backup of the database. Assuming you can restore the database, tape- based backups are accessible, and they maintain all protection group settings and backup schedules. If the DPM storage pool disks weren't affected by the outage, disk-based backups are also usable after a rebuild. You can back up the database by using different methods.

• If you back up using a DPM protection group, we recommend you use a unique protection group for the database.

• As a best practice, if you're backing up to tape, make at least two copies of the backup tapes, and store each of the backup tapes in a different remote location. This added protection guards against physical damage or loss of the backup tape.

• If the DPM SQL Server instance isn't running on the DPM server, install the DPM protection agent on the SQL Server computer before you can protect the DPM databases on that server.

  Note

  For restore purposes, the DPM installation you want to restore with the DPM database must match the version of the DPM database itself. For example, if the database you want to recover is from a DPM 2016 with Update Rollup 4 installation, the DPM server must be running the same version with Update Rollup 4. This means that you might have to uninstall and reinstall DPM with a compatible version before you restore the database. To check the database version, you might have to mount it manually to a temporary database name and then run a SQL query against the database to check the last installed rollup based on the major and minor versions.

• To check the DPM database version, follow these steps:

  1. To run the query, open SQL Management Studio, and then connect to the SQL instance that's running the DPM database.

  2. Select the DPM database, and then start a new query.

  3. Paste the following SQL query into the query pane and run it:

     Select distinct MajorVersionNumber,MinorVersionNumber ,BuildNumber, FileName FROM dbo.tbl_AM_AgentPatch order by MajorVersionNumber,MinorVersionNumber,BuildNumber

  If nothing is returned in the query results, or if the DPM server was upgraded from previous versions but no new update rollup was installed since then, there won't be an entry for the major, minor for a base installation of DPM. To check the DPM versions associated with update rollups, see List of Build Numbers for System Center Data Protection Manager (DPM).

Back up to Azure

1. Before you start, you'll need to run a script to retrieve the DPM replica volume mount point path so that you know which recovery point contains the DPM backup. Do this after initial replication with Azure Backup. In the script, replace dplsqlservername% with the name of the SQL Server instance hosting the DPM database.

Use DPMDB  -- change to match the DPMDB name if different
select sv.AccessPath,sv.Server +'\' as Folder, lr.PhysicalReplicaId as "Replica" ,'\' as "\",lr.PhysicalReplicaId as "Relica-SubFolder"
from tbl_IM_DataSource as ds
join tbl_PRM_LogicalReplica as lr
on ds.DataSourceId=lr.DataSourceId
join tbl_AM_Server as ag
on ds.ServerId=ag.ServerId
join tbl_PRM_ReplicaVolume as rp
on lr.PhysicalReplicaId=rp.ReplicaId
join tbl_STM_Volume as sv
on rp.StorageId = sv.StorageId
where ds.datasourcename like '%dpmdb%'
and servername like '%dpmsqlservername%' --netbios name of server hosting DPMDB

Ensure that you have the passcode that was specified when the Azure Recovery Services Agent was installed and the DPM server was registered in the Azure Backup vault. You'll need this passcode to restore the backup.

2. Create an Azure Backup vault, and download the Azure Backup Agent installation file and vault credentials. Run the installation file to install the agent on the DPM server and use the vault credentials to register the DPM server in the vault. Learn more.

3. After the vault is configured, set up a DPM protection group that contains the DPM database, and select to back it up to disk and to Azure.

Recover the DPM database from Azure

You can recover the database from Azure using any DPM server (must be running at least DPM 2012 R2 with update rollup 7) that's registered in the Azure Backup vault as follows:

1. In the DPM console, select Recovery > Add External DPM.

2. Provide the vault credentials (download from the Azure Backup vault).

   Note

   The credentials are only valid for two days.

3. In Select External DPM for Recovery, select the DPM server for which you want to recover the database, type in the encryption passphrase, and select OK.

4. Select the recovery point you want to use from the list of available points. Select Clear External DPM to return to the local DPM view.

Back up the DPM database to DPM storage pool

Note

This option is applicable for DPM with Modern Backup Storage.

1. In DPM console, select Protection > Create protection group.
2. On the Select Protection Group Type page, select Servers.
3. On the Select group members page, select DPM database . If you're running SQL Server remotely, select the remote SQL Server installed and select DPM database. If SQL Server is running on the DPM server, expand the DPM server and select DPMDB.
4. On the Select Data Protection Method page, select I want short-term protection using disk. Specify the short-term protection policy options.
5. After the initial replication of DPM database, run the following SQL script:

Use DPMDB  -- change to match the DPMDB name if different
select sv.AccessPath,sv.Server +'\' as Folder, lr.PhysicalReplicaId as "Replica" ,'\' as "\",lr.PhysicalReplicaId as "Relica-SubFolder"
from tbl_IM_DataSource as ds
join tbl_PRM_LogicalReplica as lr
on ds.DataSourceId=lr.DataSourceId
join tbl_AM_Server as ag
on ds.ServerId=ag.ServerId
join tbl_PRM_ReplicaVolume as rp
on lr.PhysicalReplicaId=rp.ReplicaId
join tbl_STM_Volume as sv
on rp.StorageId = sv.StorageId
where ds.datasourcename like '%dpmdb%'
and servername like '%dpmsqlservername%' --netbios name of server hosting DPMDB

Recover DPM database

To reconstruct your DPM with the same DB, you need to first recover the DPM database and sync it with the freshly installed DPM.

Use the following steps

1. Open an administrative command prompt and run psexec.exe -s powershell.exe to start a PowerShell window in system context.
2. Decide the location from where you want to recover the database:

To copy the database from the last backup

1. Navigate to replica VHD path <DPMServer FQDN><PhysicalReplicaId><PhysicalReplicaId>
2. Mount the disk0.vhdx present in it using the mount-vhd disk0.vhdx command.
3. Once the replica VHD is mounted, use mountvol.exe to assign a drive letter to the replica volume using the Physical replica ID from the SQL script output. For example, mountvol X: ?\Volume{}\

To copy the database from a previous recovery point

1. Navigate to DPMDB container directory <DPMServer FQDN><PhysicalReplicaId>; you'll see multiple directories with some unique GUID identifiers under it corresponding to recovery points taken for DPM DB. Directories other than <PhysicalReplicaId> represent a PIT/recovery point.

2. Navigate to any PIT vhd path, that is, <DPMServer FQDN><PhysicalReplicaId><PITId>, and mount the disk0.vhdx present in it using the mount-vhd disk0.vhdx command.

3. Once replica VHD is mounted, use mountvol.exe to assign a drive letter to the replica volume, using the Physical replica ID from the SQL script output. For example, mountvol X: ?\Volume{}\

   All of the following text within angular braces in the above steps are placeholders; replace them with appropriate values.

   • ReFSVolume - Access path from the SQL script output
   • DPMServer FQDN - Fully qualified domain name of DPM server
   • PhysicalReplicaId - Physical replica ID from the SQL script output
   • PITId - GUID identifier other than physical replica ID in the container directory

4. Open another administrative command prompt and run psexec.exe -s cmd.exe to start a command prompt in system context.

5. Change the directory to the X: drive and navigate to the location of the DPM database files.

6. Copy them to a location that's easy to restore from. Exit the psexec cmd window after copying.

7. Go to the psexec PowerShell window opened in step 1, navigate to the VHDX path, and dismount the VHDX by using the command dismount-vhd disk0.vhdx.

8. After reinstalling the DPM server, you can use the restored DPMDB to attach to the DPM server by running DPMSYNC-RESTOREDB command.

9. Run DPMSYNC-SYNC, once DPMSYNC-RESTOREDB is complete.

Back up the database to a secondary server

1. On the secondary DPM server, push the protection agent to the server on which the DPM database is installed - either on the primary DPM server or on a remote SQL Server. After installation, the server will appear in Unprotected server with protection agents and should show status OK when refreshed.

2. Create a new protection group. In Select group member, choose the server hosting the DPM database. In All SQL Servers, select the database you want to protect. In the Select Data Protection Method page, select to use short-term protection to disk and online if necessary. On the Specify Short-Term Goals page, select how to you want to configure backups to short-term storage. For disk storage, you can have 512 express full backups as often as every 30 minutes. Finish the wizard. Protection will start after the initial recovery point is created

Recover the database

1. Rebuild the primary server as a DPM server if necessary.

2. To restore the database, in the DPM console on the secondary server, select Recovery and locate the protected database.

3. Select the date for the recovery point you want to recover. Recover the database to the original location. After recovering the database, run the DPMSync tool.

Back up with native SQL Server backup to a local disk

You can back up the DPM database to a local disk with native SQL Server backup, independent of DPM.

1. Get an overview of SQL Server backup.

2. Learn more about backing up SQL Server to the cloud.

Back up with native SQL Server backup to a share protected by DPM

This backup option uses native SQL to back up the DPM database to a share, protects the share with DPM, and uses Windows VSS previous versions to facilitate the restore.

Before you start

1. If the DPM database is located on a remote SQL Server, install the DPM agent on that server.

2. On the SQL Server, make a folder on a drive with enough free space to hold a single copy of a backup. For example: C:\DPMBACKUP.

3. Share the folder. For example, share C:\DPMBACKUP folder as DPMBACKUP.

4. Copy and paste the OSQL command below into Notepad and save it to a file named C:\DPMBACKUP\bkupdb.cmd. Ensure that there's no .txt extension. Modify the SQL_Instance_name andDPMDB_NAME to match the instance and DPMDB name used by your DPM server.

   OSQL -E -S localhost\SQL_INSTANCE_NAME -Q "BACKUP DATABASE DPMDB_NAME TO DISK='C:\DPMBACKUP\dpmdb.bak' WITH FORMAT"
   
   

5. Using Notepad, open the ScriptingConfig.xml file located under the ...\DPM\Scripting folder.

   • On a remote SQL Server: C:\Program Files\Microsoft Data Protection Manager\DPM\Scripting

   • On a DPM server: C:\Program Files\Microsoft System Center\DPM\DPM\Scripting

6. Modify ScriptingConfig.xml and change DataSourceName= to be the drive letter that contains the DPMDBBACKUP folder/share. Change the PreBackupScript entry to the full path and name of thebkupdb.cmd saved in step 5.

   <?xml version="1.0" encoding="utf-8"?>
   <ScriptConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns:xsd="http://www.w3.org/2001/XMLSchema"
   xmlns="https://schemas.microsoft.com/2003/dls/ScriptingConfig.xsd">
   <DatasourceScriptConfig DataSourceName="C:">
   <PreBackupScript>C:\DPMDBBACKUP\bkupdb.cmd</PreBackupScript>
   <TimeOut>120</TimeOut>
   </DatasourceScriptConfig>
   </ScriptConfiguration>
   

7. Save the changes to ScriptingConfig.xml.

8. Protect the C:\DPMBACKUP folder or the \\sqlservername\DPMBACKUP share using DPM and wait for the initial replica to be created. There should be a dpmdb.bak in the C:\DPMBACKUPfolder as a result of the pre-backup script running, which was in turn copied to the DPM replica.

Configure the DPM Database backup using Native SQL Server

You can back up the DPM database as you would any other SQL Server database using SQL Server native backup.

• Get an overview of SQL Server backup.

• Learn more about backing up SQL Server to the cloud.

Using DPMSync

DpmSync is a command-line tool that enables you to synchronize the DPM database with the state of the disks in the storage pool and with the installed protection agents. DpmSync restores the DPM database, synchronizes the DPM database with the replicas in the storage pool, restores the Report database, and reallocates missing replicas.

Parameters

Parameter	Description
-RestoreDb	Restores a DPM database from a specified location.
-Sync	Synchronizes restored databases. You must run DpmSync –Sync after you restore the databases. After you run DpmSync –Sync, some replicas may still be marked as missing.
-DbLoc location	Identifies the location of backup of DPM database.
-InstanceName  server\instance	Instance to which DPMDB must be restored.
-ReallocateReplica	Reallocates all missing replica volumes without synchronization.
-DataCopied	Indicates that you have completed loading data into the newly allocated replica volumes. This is applicable for client computers only.

Example 1: To restore the DPM database from local backup media on the DPM server.
Run the following command:

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

After you restore the DPM database, to synchronize the databases, run the following command:

DpmSync -Sync

After you restore and synchronize the DPM database and before you restore the replica, run the following command to reallocate disk space for the replica:

DpmSync -ReallocateReplica

Example 2: To restore the DPM database from a remote database.
Run the following command on the remote computer:

DpmSync –RestoreDb -DbLoc G:\DPM\Backups\2005\November\DPMDB.bak –InstanceName contoso\ms$dpm

After you restore the DPM database, to synchronize the databases, run the following command on the DPM Server:

DpmSync -Sync

After you restore and synchronize the DPM database and before you restore the replica, run the following command on the DPM Server to reallocate disk space for the replica:

DpmSync -ReallocateReplica