Remove Deleted and NoDataSourceProtected Servers from the DPM SQL Database RRS feed

  • Question

  • Hello,

    We are using DPM 2012 SP1 UR6 with SQL 2012 latest version.

    ServerName      ClusterName                                     Domain                              ServerProtectionState
    Filer                              Deleted
    FILER                                                                                 HasDatasourcesProtected
    FILER1                                                                               Deleted
    FILER2                                                                               Deleted
    FSG                                        NoDataSourceProtected

    1 - How do I clean up the SQL database for DPM so it does not show these old Servers that used to have Protection?
    I want to remove the ones that show Deleted and NoDataSourceProtected out of the database.

    There are many more than what I show listed here. DPMDB is over five years old.

    2 - In addition, one of them shows a duplicate Protection name, with one deleted and the other one currently Protected (Filer and FILER).
    The problem is when trying to Recover a file it points to the one that has been deleted ( and then fails when choosing "Recover to Original Location."

    Type:    Disk recovery
    Status:    Failed
    Description:    DPM was unable to access the cluster resource group for H:\ of protection group Profiles and Documents. Recover the datasource using the alternate location workflow. (ID 32579)

    Trying to find a way to correct this without having to remove the Protection and recreate.

    Thank you,


    Thursday, July 10, 2014 9:25 PM

All replies

  • I'd like to know this as well. DPM is probably the worst part of system center I've used.

    i.e. Discovery data that never goes away? Like Denise, I have hundreds of computer objects that simply no longer exist in AD still in DPM with no way to remove them from view.

    Tuesday, October 28, 2014 2:33 PM
  • I have the same issue, 

    Around 30 deleted protected objects in DPM that no longer exist... and RemoveProductionServer doesn't work.

    I'm also wondering how i can ever delete them from dpm. Although they aren't listed inside the GUI. 

    Monday, July 27, 2015 10:09 AM
  • Hello

    I have the same issue

    Have any poeple a Idee, how i can delete them from dpm.

    Thanks for help

    Friday, February 26, 2016 8:54 AM
  • I have the same issue here.

    I run the following command and get 6 servers that aren't listed anywhere in the GUI console:

    Get-ProductionServer | where {$_.ServerProtectionState -eq "Deleted"}

    How on earth are we supposed to remove them from DPM? The only way I thought was this:

    1. Create a 'donor' PC
    2. Rename it to the first old server in the 'Deleted' list
    3. Install the DPM agent onto it
    4. Uninstall the DPM agent from it
    5. Repeat for every 'Deleted' server in the list

    I shall try this and report back.

    • Edited by AndyChips Wednesday, June 8, 2016 2:28 PM
    Wednesday, June 8, 2016 2:28 PM
  • Well, that didn't work. I can install an agent on the 'donor' PC and the DPM server removes it from the 'Deleted' list. All Ok so far... but as soon as I uninstall the agent the computer name reappears in the 'Deleted' list.
    Wednesday, June 8, 2016 3:08 PM