none
Upgrading SQL on DPM 1801 RRS feed

  • Question

  • Hi,

    I'm curious to see if anyone knows of best practice for upgrading SQL server on DPM servers? Some of my DPM servers are not on the same version (SQL 2012 & 2014) and I'd like to upgrade them all to SQL 2016 SP2. 

    Is there anything special I need to do with DPM? Or is it a straightforward SQL upgrade?

    Thanks in advance,

    Josh

    Monday, March 11, 2019 9:37 PM

Answers

All replies

  • Hello Josh,

    Are your DPM databases installed locally (on the DPM server) or remotely?


    I can line down the steps for you here:

    1. Backup the DPM database (.bak files).

    2. If the SQL server is on a remote server, copy the backup (.bak files) to the remote server.

    3. Restore the DPM database to the new SQL server.

    4. Uninstall DPM.

    5. Reinstall DPM and target the new SQL server during the setup.

    6. Restore the original DPM database by using the following command:

    DPMSync -RestoreDB

    7. Then run a sync command:

    DPMSync -Sync

    8. Finally run a consistency check on all your data sources.

    Hope this helps!

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Monday, March 11, 2019 9:53 PM
  • Hi Leon,

    Thanks for the reply. The DPM database is installed locally on the DPM Server. I also just want to reiterate that this is for an in-place upgrade of SQL. Would an uninstall of DPM still be required?

    As far as I was aware, it's typically just backing up the DPM Database prior to upgrade and stopping the DPM Services prior to upgrade as well. And the SQL version can be upgraded without much regard for DPM. Am I incorrect in that thinking?

    Thank you,

    Josh

    Monday, March 11, 2019 10:44 PM
  • Ok, I assumed you were running the database remotely. If your DPM database is installed locally on the DPM server, then all you have to do is:

    1. Shut down all the DPM services.

    2. Backup your DPM database (just in case).

    3. Perform an upgrade installation of SQL Server.

    4. Start the DPM services.


    SQL Server 2016 supports upgrade from the following versions of SQL Server:

    • SQL Server 2008 SP4 or later
    • SQL Server 2008 R2 SP3 or later
    • SQL Server 2012 (11.x) SP2 or later
    • SQL Server 2014 (12.x) or later


    More information in the link below:

    Upgrades from Earlier Versions to SQL Server 2016 (13.x)

    https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades?view=sql-server-2016#upgrades-from-earlier-versions-to-


    Blog: https://thesystemcenterblog.com LinkedIn:

    • Marked as answer by Mr.Josh.ua Monday, March 11, 2019 11:31 PM
    Monday, March 11, 2019 11:03 PM
  • Thanks Leon!
    Monday, March 11, 2019 11:13 PM
  • You're welcome Josh.

    If you have any other concerns, do feel free to ask!

    (Please don't forget to mark as answer if this answered your question)


    Blog: https://thesystemcenterblog.com LinkedIn:

    Monday, March 11, 2019 11:15 PM