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

Erroneous Log Backup Overdue alerts

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.
Rhys
0

Comments

3 comments

Sort by
  • chriskelly
    The alert generates based on information found in the dbo.backupset table in the msdb database.

    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]
    chriskelly
    0
  • Rhys
    Yes, the query return ok for all log backups at 6AM. Log file viewer for the job says the job ran ok at 6AM.

    Same thing happened again at 6:20 this morning.
    Rhys
    0
  • chriskelly
    Thank you for your reply.

    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#
    chriskelly
    0

Add comment

Please sign in to leave a comment.