none
DPM Multiple SQL Databases? RRS feed

  • Question

  • Hello,

    Currently I'm trying to prepare for a disaster scenario when I lose the DPM server and all the data including DPM SQL database.

    Therefore, I want to make a backup plan for the DPM SQL Database.

    I logged into the SQL server where the DPM database is saved to find there are multiple DPM databases:

    I checked in the DPM Administrator Console and deduced that one with 875 is the database that is being used.

    My questions are as follow:

    1. Is it safe to delete the other DPM databases? Are they older versions? Are all the databases being used?

    2. If not then when i restore them (theoretically) on a new SQL Server do I have to manually point the DPM to that specific database?

    Thank you in advance.

    Friday, October 19, 2018 8:35 AM

Answers

  • Hi Bogdan,

    Why there are DPM databases with different GUIDs is most likely if you have upgraded DPM versions.

    1. If it's not in use it can be deleted, you should be able to delete it as DPM uses only one database (except for the Reporting Services), if you do decide to delete the other databases, make sure you do take a backup of the database first!.

    2. When you restore a DPM database, you will have to use the DPMSync cmdlet to point to the correct database.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Friday, October 19, 2018 10:19 AM

All replies

  • Hi Bogdan,

    Why there are DPM databases with different GUIDs is most likely if you have upgraded DPM versions.

    1. If it's not in use it can be deleted, you should be able to delete it as DPM uses only one database (except for the Reporting Services), if you do decide to delete the other databases, make sure you do take a backup of the database first!.

    2. When you restore a DPM database, you will have to use the DPMSync cmdlet to point to the correct database.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Friday, October 19, 2018 10:19 AM
  • To be honest... I was expecting you to answer. 

    Thank you for all the great help and guidance Leon... It seems like you are always the first to answer my "cries for help". 

    I will back them up before doing anything.

    One more question:

    After I see that that is indeed the database used can i rename it and then dpmsync?

    The name isn't that intuitive...

    Friday, October 19, 2018 11:01 AM
  • Happy to help!

    You "can" rename the database (but I wouldn't recommend it), but you will have to uninstall DPM and then reinstall it and then run DPMSync.


    Blog: https://thesystemcenterblog.com LinkedIn:

    Friday, October 19, 2018 11:34 AM
  • I'd rather not do that haha.

    Thank you once again for all the great help.

    Friday, October 19, 2018 11:49 AM
  • You're welcome!

    Blog: https://thesystemcenterblog.com LinkedIn:

    Friday, October 19, 2018 11:50 AM