DPM 2019: SQL Server protection groups do NOT perform automatic consistency checks

Stefan Falk 166 Reputation points
2022-07-15T07:25:04.213+00:00

Hello everybody,

on our own installation and at ALL our customers using DPM 2019, DPM does not perform automatic consistency checks (we waited for days!) when SQL source become inconsistent - despite the protection group having automatic consistency checks activated. These protection groups to only contain SQL Server databases, but often from several servers and instances.

With any other protected loads, automatic consistency checks occur, just not with SQL Server sources.

Best Regards,
Stefan

And: Why on earth are there no tags for DPM available in the "Tags" field here?

Windows Server Backup
Windows Server Backup
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Backup: A duplicate copy of a program, a disk, or data, made either for archiving purposes or for safeguarding valuable files from loss should the active copy be damaged or destroyed.
439 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Limitless Technology 39,186 Reputation points
    2022-07-19T07:38:00.34+00:00

    Hello

    Thank you for your question and reaching out. I can understand you are having issues related to DPM consistency checks.

    1. Please try to Reboot DPM and apply Latest updates of DPM.
    2. If that fails DPM tries again and again.
      After several attempts DPM will stop trying to run it and you have to start it manually or wait one or more days but that is not a very smart option because you don't get backups while the replica is inconsistent.
    3. You can control the CC delay (amount of time to wait before a CC runs) and number of CC attempts before giving up using the below registry values.

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Data Protection Manager\Configuration]
    "AutoCCDelay"=dword:0000000F
    "AutoCCNumberOfAttempts"=dword:00000004

    -----------------------------------------------------------------------------------------------------------------------------------

    --If the reply is helpful, please Upvote and Accept as answer--

    0 comments No comments