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

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.

James April 10, 2019 13:51

Comments

1 comment

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

Dan B April 29, 2019 13:05

0

Add comment

Please sign in to leave a comment.

How can we help you today?

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

Comments

Add comment