none
"DPM detected changes in existing protected objects" after manual failover - DPM 2016 - SQL Server 2016 Always On Availability Group RRS feed

  • Question

  • After an Always On Availability Group manual failover, on next incremental sync DPM fails with error

    "The replica of SQL Server 2016 database <AGName/DBName> on <AG FQDN> is not consistent with the protected data source. 
    DPM detected changes in existing protected objects and detected new protectable objects for the data source since it was configured for protection. (ID 30138)"

    DPM 2016 Update 2 (5.0.322) - server and agents - on Windows Server 2016  (version 1607), in Hyper-V VM.

    Trying to protect SQL Server Enterprise 2016 (13.0.1601.5) on Windows Server 2016 (Version 1607) in Hyper-V VM.  Two instances on two VMs, same domain, using Windows Server Failover Clustering. Availability Group configured for synchronous commit and for backup only of primary.  On each SQL Server host the DPM computer is in the local Users group, which has Access this computer from the NEtwork.  On each SQL instance NT Authority\System and NT Service\DPMRA are in the sysadmin group.  One database in Always On AG, database shows synchronized on both instances. 

    Initial replica creation, an express full, and several incremental syncs are completed without error, but after a manual failover of Availability Group the next incremental sync fails with the error listed above.

    Suggestions?

    thanks!

    Martin

    Friday, August 18, 2017 12:20 AM

Answers

  • Update - 

    Per MS support, this is expected behavior; after a failover there must be a consistency check before more recovery points can be created.  If "run a consistency check if a replica becomes inconsistent" is checked on the protection group, it seems that a consistency check will be run fairly soon and fix the situation.

    It appears that even though the first incremental sync failed, no transactions/history are lost (at least in this synchronous-commit scenario).

    Hope this helps someone.

    Martin

    • Marked as answer by MartinBH Wednesday, August 23, 2017 11:30 PM
    Wednesday, August 23, 2017 11:30 PM