Alerts not clearing

In my active alerts, I have a server that is saying that the databases have not been backed up in XXX days.
I've resolved the problem, but the alerts are not clearing.
When I go and look at the database backup data, the "Last Backup" data is correct (and under the alert level)

What can I do to clear the resolved alerts?

Note: This is happening for more than one server, but not all of them.

Parents Reply Children
  • If I recall correctly, the "Days since last since last backup" alert is based on data that is collected every hour (by default). The default setting can be changed on the Monitored SQL Server Properties window on the General tab (the "Collect and alert on database metrics" option).

    If the alert persists past the period specified, I'd recommend opening a support ticket. 

    On a side note, it would be worthy to note whether the affected monitored instances are part of an availability group or not.

  • Yep this worked for me. Thanks sqlraider