Log backup overdue alert when using SIMPLE recovery model

jonwilk

Hi

I'm now getting daily alerts saying
"Alert type: Log backup overdue"
for multiple databases that are set to use the SIMPLE recovery model.

I am taking FULL backups of these databases each day, but obviously you can't backup the transaction log for a database in this recovery model.

Am I doing something wrong, or should i not be receiving these alerts?

Many thanks

chriskelly

You can disable the log backup overdue alert.

In the Configuration > Alert Settings page, you can either make this choice for all monitored servers, or you can use the list of Monitored servers on the left hand side to make the change at the machine level, sql server level or individual database level.

priyasinha

Hi Jon,

This is not the designed/ expected behaviour. If the model of the database is "Simple" then SQL Monitor shouldn't send you "Log backup overdue" alert. Have you modified the model of the database recently?

Thanks,
Priya

rohitkumar

HI,

I am getting alert Log backup overdue alert when I am  using FULL recovery model.
Please suggest me, How resolve this issue.

Thanks