How can we help you today? How can we help you today?

Log backup overdue alert when using SIMPLE recovery model

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
jonwilk
0

Comments

3 comments

Sort by
  • 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.
    chriskelly
    0
  • 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
    priyasinha
    0
  • 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

    rohitkumar
    0

Add comment

Please sign in to leave a comment.