Erroneous Log Backup Overdue alerts
Rhys
Posts: 35
Occasionally we seem to receive log backup overdue alerts when we should not.
The alerts are raised as "Medium" which we have set to 3 hours. However the alerts are always raised at 6:20AM and then immediately closed. The last successful log backup was at 6AM which the alert acknowledges.
I've checked the log backups in SSMS and they have run without error.
The alerts are raised as "Medium" which we have set to 3 hours. However the alerts are always raised at 6:20AM and then immediately closed. The last successful log backup was at 6AM which the alert acknowledges.
I've checked the log backups in SSMS and they have run without error.
Comments
As a quick test, please run the following query. Does it return the transaction log backup which occured at 6am? (backup.type should = L)
SELECT backupset.backup_set_id, backupset.name, backupset.user_name, backupset.backup_start_date, backupset.type
FROM [msdb].[dbo].[backupset]
Same thing happened again at 6:20 this morning.
I think that you may be suffering from a known problem. Please can you upgrade to v2.3, which was released yesterday, as I believe that it contains a fix which will solve this for you.
Here is the link to the download:
http://www.red-gate.com/products/dba/sq ... /download#