We were testing ADR in a two SQL Server 2019 CU 4 Developer Edition servers, with a AG setup. After enabling ADR for every database in those instances, the secondary server started to log this message “[DbId:XX] ADR enabled for the database.” in the ErrorLog every fifteen seconds or so for a given database if there was a transaction in that database in the primary server within those seconds.
Ie. We have queries constantly reaching db ids 14 and 40, so we see that message constantly in the secondary for those db ids. For the dbid 16, I just created a table and run few scripts for tests purposes, so we see only one entry for that db id there after my tests.
The thing is, even if I disable ADR now, I keep seeing the disabled messages. Disabling ADR for db id 40, after few minutes, this what we get:
I have tried to failover and reboot both instances, but didn’t help. I’ve tried also to remove and rejoin the databases to AG, didn’t work either. Tried to set the ADR before the database being part of the AG, took log backups, but as soon as I join the database to the AG I start to see those messages in the secondary.
I’ve submitted a bug to MS here (please vote if it has happened to you too):
https://feedback.azure.com/forums/908035-sql-server/suggestions/40974028–dbid-xx-adr-enabled-for-the-database-logged-a
Also asked the question on SQL Forum:
https://social.technet.microsoft.com/Forums/windows/en-US/92fba721-93a1-46f8-8923-99fc2d691326/quotdbidxx-adr-enabled-for-the-databasequot-logged-all-the-time-in-errorlog?forum=sqlkjmanageability
Has anyone experience the same? Is there any way to suppress those messages from ErrorLog? Any workaround?
UPDATE 23/10/2020: Apparently it has been fixed on CU 8 :
“Fixed an issue with excessive number of informational messages in the Error log when Accelerated Database Recovery (ADR) is disabled for a database. “
I have tested that and it seems to be gone indeed.
Thanks. 🙂