Log backup overdue alert when using SIMPLE recovery model

jonwilkjonwilk Posts: 32
edited May 24, 2011 4:52AM in SQL Monitor Previous Versions
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

Comments

  • 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.
  • 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
    Priya Sinha
    Project Manager
    Red Gate Software
  • rohitkumarrohitkumar Posts: 1 New member
    HI,

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

    Thanks

Sign In or Register to comment.