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.