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

jt25jt25 Posts: 1 New member
edited April 10, 2019 1:53PM in Redgate Monitor
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. 
Tagged:

Answers

Sign In or Register to comment.