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

Question

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?

Answer 1

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--