If you are running SQL Server 2016 (especially before CU3) you have received this error:
DATE/TIME: 8/21/2017 11:24:53 AM
DESCRIPTION: Always On Availability Groups transport has detected a missing log block for availability database "Database". LSN of last applied log block is (99939:95847:0). Log scan will be restarted to fix the issue. This is an informational message only. No user action is required.
COMMENT: (None)
JOB RUN: (None)
I’ve talked with the product team about it, and its just something that happens, and is more of an informational message. Based on some discussions I’ve have on #sqlhelp on Twitter, it may be related to not enough network bandwidth between nodes. But if you see these sporadically, relax, it’s nothing major.
Hi Joey…this is happening on a system of mine and is sending the database into and through recovery on the Secondary. Its supposedly fixed in both CU 8 and 20 for SQL 2017. I’m looking at an emergency patch and drop/re-add the DB (800GB). Just FYI for you and future readers –Kevin3NF