michael

Here is my situation:

I have a stored procedure that runs full, differential and
log backups for a particular database.

Each backup has unique name based on the type, day of the
week and the time (e.g. Full_Backup_Monday_12-30).
Thus, backups are kept for one week.

When I review the backup set table, I see the name of my
backup, but in many cases I see an old date for the backup
and start and completion dates. However, when I review
the server, the newer backups are present.

My questions are:
Why isn't the backupset table being updated with the most
recent information?

When is the backupset table updated?

Thanks,
Michael