This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Scenario:
Running DPM 1807 on several servers with their DBs on the same common remote 2016 SQL server.
To upgrade them, SQLPrep for the 2019-version has to be run on the SQL server, the question:
Will this break DPM on the other 1807-servers until they're are also upgraded to 2019? Or is the SQLPrep backwards compatible? (Rebuilding DPMs can be a pain...)
Thanks.
Additional System Center tools and components for managing infrastructure, applications, and services
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 92%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXM%3C/text%3E%3C/svg%3E)
OK, I got your problem. SQLPrep only check prerequisites for DMP2019 will not break other DPMs.
note: A backup should be taken before upgrading.
Here is a DPM Step-By-Step: upgrading to v2019 guide for your reference.
Hi,
We can't install DPM 2016 on SQL 2016 SP1 or a later release.
Issue: Installation on SQL 2016 SP1 (or a later release) isn't supported.
https://learn.microsoft.com/en-us/system-center/dpm/prepare-environment-for-dpm?view=sc-dpm-2016
https://learn.microsoft.com/en-us/system-center/dpm/prepare-environment-for-dpm?view=sc-dpm-2019
I do not understand your answer... to clarify my case:
We are already running several 1807 DPMs with a common, remote 2016 SQL server without problems.
Now we want to upgrade the DPms to DPM2019, SQL 2016 is supported for DPM 2019. But have to run DPM 2019's SQPrep on the SQL-server before DPM2019 will install/upgrade on the first DPM. To repeat the question: Will the SQLPrep for DPM2019 break the other DPMs until they are also upgraded to DPM 2019?