In an AlwaysOn environment with backup preferences is set to Primary, I do not want the alert for Backup overdue and Log backup overdue
is it possible to remove backup alert on not readable databases in an AlwaysOn environment
Odd Mikalsen commented
I do not want to disable this alert, if I do that I have to manually set the alert on and off when I move the primary database between the nodes.
Thanks for your feedback John.
John McP commented
I am also looking for this feature.
Priya, I am currently doing what you are suggesting but this needs to be done every time the primary server is changed in the Availablity Group - its not ideal and can be easily forgotten.
The system function sys.fn_hadr_backup_is_preferred_replica can be used to determine if the server is currently the preferred backup server.
You can navigate to Configuration > Alert Settings page. Select the database on the left hand pane under "All servers". Then select 'Backup overdue' alert in right hand pane and disable this alert. Another way or quickest way to navigate to Alert settings page is, if you already have a 'Backup overdue' alert then open the alert and click on 'Configure alert...'.
Is this what you are after?