none
Configure DPM Server Database on SQL Clustered Server RRS feed

  • Question

  • Hi,

    After testing DPM solution, we are not going to deploy production DPM server and for that we need SQL database pre-configured. We already have SQL cluster running some different instances and we would like to use the same server and create new instance for DPM server.

    Can someone please provide steps to do the same.

    Also as per https://docs.microsoft.com/en-us/system-center/dpm/install-dpm?view=sc-dpm-2019 this link, if database server is clustered then SQL reporting service needs to be on different server than the clustered servers. Does that mean we need to install SQL for just reporting services on different server and also what about SQL license for just installing reporting service ? Do we need license to run only SQL reporting service ?

    Thursday, October 17, 2019 3:25 PM

Answers

  • You will have to use a standard "active-standby" cluster, because DPM does not an support Always-On deployment.

    In short:

    - Install at least two (2) servers and create a failover cluster.

    - Configure the shared storage for the failover cluster.

    - Install the SQL Server on all cluster nodes (Create a New SQL Server Failover Cluster (Setup))

    Note: 
    If you're running a remote database, have it ready before you install DPM, make sure to run DPM Remote SQL Prep tool on remote SQL computers:


    Blog: https://thesystemcenterblog.com LinkedIn:

    • Proposed as answer by Leon Laude Thursday, November 14, 2019 4:07 AM
    • Marked as answer by SC2317 Thursday, January 2, 2020 2:36 PM
    Friday, October 18, 2019 4:48 PM

All replies

  • Hello,

    The SQL Server Reporting Services (SSRS) should be installed on another server if you're going to have the DPM database clustered, no additional licenses are needed for the management server or SQL Server runtime
    (SQL Server Standard Edition).

    All of the System Center products include SQL Server technology. Microsoft's licensing terms for these products allow customer use of SQL Server technology only to support System Center components.

    You can use the same license key for your DPM instance as for the SSRS instance.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Thursday, October 17, 2019 4:03 PM
  • Thanks. Is it good idea to keep reporting services on the same server where DPM application is running and keep the database on the cluster environment ?

    Also, I would like to perform test where if my DPM server crash then how can I restore its database. Could you please suggest on the same.

    As of now I am not planning to deploy 2 DPM servers where one can take care of backup of other. How can I achieve this ?

    • Marked as answer by SC2317 Friday, October 18, 2019 12:02 PM
    • Unmarked as answer by SC2317 Friday, October 18, 2019 12:03 PM
    • Marked as answer by SC2317 Friday, October 18, 2019 12:03 PM
    • Unmarked as answer by SC2317 Friday, October 18, 2019 12:04 PM
    Friday, October 18, 2019 11:52 AM
  • Thanks. Is it good idea to keep reporting services on the same server where DPM application is running and keep the database on the cluster environment ?

    >> Yes this is totally possible, I've had many customers do it, as the Reporting Services can only be a standalone, the DPM server is a suitable place for it.

    Also, I would like to perform test where if my DPM server crash then how can I restore its database. Could you please suggest on the same.

    As of now I am not planning to deploy 2 DPM servers where one can take care of backup of other. How can I achieve this ?

    >> I would gladly like to assist you, I would however suggest you to create a new thread for this as it is a different query, this is simply to keep the threads within their subject (thread title), thanks!


    Blog: https://thesystemcenterblog.com LinkedIn:

    Friday, October 18, 2019 11:58 AM
  • Thanks. I have created another thread for this.

    Can you please provide me steps or some reference link that I can follow to create new SQl instance for DPM backup. I already have few instances running on existing SQL cluster and would like to use same cluster for DPM backup.

    Friday, October 18, 2019 12:05 PM
  • Does this mean that if I use DPM server and configure SQL server for its database then I don't need to license that SQL server ?
    Friday, October 18, 2019 12:06 PM
  • Can you please provide me steps or some reference link that I can follow to create new SQl instance for DPM backup. I already have few instances running on existing SQL cluster and would like to use same cluster for DPM backup

    >> Not sure I fully understand, a basic installation of the DPM SQL database? 

    Does this mean that if I use DPM server and configure SQL server for its database then I don't need to license that SQL server ?

    >> Correct, you have the right to use a SQL Server standard instance for the purpose of DPM only.


    Blog: https://thesystemcenterblog.com LinkedIn:

    Friday, October 18, 2019 12:11 PM
  • Thanks. By SQL clustered installation, I meant that if I already have clustered servers running production SQL instances on that,then how can I configure separate SQL instance for DPM database on that.
    Friday, October 18, 2019 12:16 PM
  • I believe you would have to have ONLY the DPM SQL Server on the cluster for the license to be valid, but I would strongly recommend asking licensing questions to a trained Microsoft licensing specialist.

    Blog: https://thesystemcenterblog.com LinkedIn:

    Friday, October 18, 2019 12:46 PM
  • ok great thanks. Any suggestion on configuration of DPM SQL instance on remote clustered SQL server ?
    Friday, October 18, 2019 1:35 PM
  • You will have to use a standard "active-standby" cluster, because DPM does not an support Always-On deployment.

    In short:

    - Install at least two (2) servers and create a failover cluster.

    - Configure the shared storage for the failover cluster.

    - Install the SQL Server on all cluster nodes (Create a New SQL Server Failover Cluster (Setup))

    Note: 
    If you're running a remote database, have it ready before you install DPM, make sure to run DPM Remote SQL Prep tool on remote SQL computers:


    Blog: https://thesystemcenterblog.com LinkedIn:

    • Proposed as answer by Leon Laude Thursday, November 14, 2019 4:07 AM
    • Marked as answer by SC2317 Thursday, January 2, 2020 2:36 PM
    Friday, October 18, 2019 4:48 PM
  • Hi,

    Just checking to see if you have any update on your issue?

    If your issue was resolved, may I ask you to mark all the answers that helped you? This way it will also help others in the future who face the same challenge. Many thanks in advance!


    Best regards,
    Leon

    Blog: https://thesystemcenterblog.com LinkedIn:

    Wednesday, December 11, 2019 9:40 PM