Log backup overdue alert when using SIMPLE recovery model
jonwilk
Posts: 32
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
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
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.
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
Project Manager
Red Gate Software
I am getting alert Log backup overdue alert when I am using FULL recovery model.
Please suggest me, How resolve this issue.
Thanks