SQL Monitor AG alert for mismatched LSNs during Log backup on secondary.

jt25

I am getting this error on an availabilty group installation below and i was wondering if there is an alert in SQL Monitor that can be sent when it happens. 2 Node Cluster with SQL Server 2017 Enterprise CU12 on a Azure VMs in sychronous mode and we are getting the error in the Azure Backup Vault. I would like to see if SQL monitor can catch it before the Azure Backup Vault fails to backup every 15 minutes. 

Error is... Log backup for database "XXX" on a secondary replica failed because the last backup LSN from the primary database is greater than the current local redo LSN. 

Dan B

Hi jt25,

Thanks for posting on the Redgate forum.

At present, there isn't a method for achieving this inside of SQL Monitor. I would advise raising a feature request on our uservoice site here https://sqlmonitor.uservoice.com/forums/91743-suggestions