How do you use cloud databases? Take the survey.
Options
SQL Monitor AG alert for mismatched LSNs during Log backup on secondary.
jt25
Posts: 1 New member
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.
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.
Answers
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 Bainbridge
Product Support Engineer | Redgate Software