none
Multiple DPM servers with 1 DB? RRS feed

  • Question

  • I would like to have multple DPM servers acting as 1 unit.

    Example.

    Backup on server a in building a, store tape in building b.

    If I need a restore, I can put the tapes in building b and restore over the WAN.

    I can do this currently with NetBackup.

    It has 1 DB server and multiple "Media Servers" each with their own libraries.

    Backups are set to run to a set Media Server, but restores can run from wherever the tapes are inventoried, since they are recorded in the same DB.

    Can DPM do this?

    Another scenario would be DPM server A backs up most data, but fileserver C has a local library.  Can backups be run from server C directly to local tapes, but record the backups/tapes on DPM server A?

    Tuesday, December 18, 2012 8:17 PM

Answers

  • Hi,

    Each DPM server maintains it's own SQL database.  DPM 2012 supports sharing a single SQL instance so all databases are hosted on a single SQL server in a single instance, but each DPM server will have a seperate database.  DPM can share a single tape library, but each DPM server maintains their own tape inventory.  DPM does not have a seperate library agent so backups can be performed on a locally attached tape drive / library on a protected server.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, December 19, 2012 12:26 AM
    Moderator

All replies

  • Hi,

    Each DPM server maintains it's own SQL database.  DPM 2012 supports sharing a single SQL instance so all databases are hosted on a single SQL server in a single instance, but each DPM server will have a seperate database.  DPM can share a single tape library, but each DPM server maintains their own tape inventory.  DPM does not have a seperate library agent so backups can be performed on a locally attached tape drive / library on a protected server.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, December 19, 2012 12:26 AM
    Moderator
  • That's terrible news.

    So it is no better than Backup Exec?

    I assumed as part of System Center, that this would be more of an Enterprise Tool.


    Thursday, December 20, 2012 1:57 PM
  • Hello Mike,

    Is it possible for multiple DPM servers to backup to a single tape unit? The tape unit will be connected to one of the DPM servers.

    Thursday, May 16, 2013 2:14 PM
  • Hi,

    You can use System Center 2012 Operations manager and install the DPM unified console and DPM management packs and that allows you to manage all the DPM servers from a single unified console.  But each DPM server is independent.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Thursday, May 16, 2013 3:10 PM
    Moderator
  • H.W.

    Tape library sharing can be configured using the following TechNet article:

    How to Set Up Tape Library Sharing
    http://technet.microsoft.com/en-us/library/hh758124.aspx

    NOTE: This is currently broken if you are running on DPM 2012 UR2 - we have a workaround if you bump into this error:

    Running SetSharedDpmDatabase.exe to enable tape library sharing fails with the following error after applying UR2:

    (dpm1) : Global SQL Server configuration Successful.
    Failed to execute RBACRolePermissionOnStoredProcScript.sql on DPM2\MSDPM2012


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Thursday, May 16, 2013 3:15 PM
    Moderator
  • What is the work around?
    Monday, June 3, 2013 8:50 PM
  • Hi,

    The workaround is to create a dummy procedure named 'prc_IM_DataSources_All_WithInactiveTapeSets' in the DPM database that does not
    do anything, in management studio execute:


    Use <DPM DATABASE>

    Create procedure
    prc_IM_DataSources_All_WithInactiveTapeSets
    as


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, June 4, 2013 2:30 PM
    Moderator
  • Hi,

    Thanks for sharing the workaround. I've just hit this problem and have a question:

    Do you apply the workaround  procedure to all client databases and then re-run :

    "SetSharedDpmDatabase -DatabaseName BAP-DPM04\MSDPM2012\DPMDB -DoNotMoveData"

    Regards

    Lachlan

    Thursday, July 18, 2013 2:32 AM
  • Hi,

    Yes, any DPM server can act as the library control server or be a client, so you should use the workaround on all dpm servers regardless of it's current role.

    FYI, this issue is fixed in the next rollup fix coming soon.

    UPDATE:  This issue is fixed in UR3.

    Description of Update Rollup 3 for System Center 2012 Service Pack 1
    http://support.microsoft.com/kb/2836751


    Issue 1
    When you try to set up library sharing when you use Data Protection Manager SP1 Update Rollup 2, you receive the following error message:
        Failed to execute RBACRolePermissionOnStoredProcScript.sql on DPMServer\Database


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.


    Thursday, July 18, 2013 2:43 AM
    Moderator
  • Should this procedure be run before or after executing:

    "SetSharedDpmDatabase -DatabaseName BAP-DPM04\MSDPM2012\DPMDB -DoNotMoveData"

    Thursday, July 18, 2013 2:57 AM