How it works...

Upgrading DPM 2012 R2 to the latest DPM release is a straightforward process. In this example, we are running SQL Server 2012 with SP3 as a local instance on the same OS.

As a part of your upgrade, you may also want to move the DPM database if you ever encounter the following scenarios:

• You are merging instances of SQL Server.
• You are moving to a remote SQL Server that's more powerful than SQL Server.
• You want to add fault tolerance by using a SQL Server cluster.
• You want to move from a remote SQL Server to a local SQL server or vice versa.

The DPM setup allows you to migrate the DPM database to different SQL Servers during the upgrade process.