Backup Sets containing SQL database backups may expire prematurely.
book
Article ID: 100033941
calendar_today
Updated On:
Cause
When the system databases are automatically switched to a full backup method during an incremental backup job, it removes the dependency on the prior backups from the associated user database backup set. Since the prior full and incremental backups are no longer part of the dependency chain, they can be deleted if the retention period expires before the depending incremental backups.
Resolution
A hotfix is now available for this issue in the current version of the product mentioned in this article. Refer to the Hotfix link under Related Articles to obtain the hotfix needed to resolve the issue.
Backup Exec 16 Rev 1142 Feature Pack 2 (
000116194)
Workaround
To work around this issue, perform either A) or B)
A) Edit the backup solution such that the Full backup job has a retention setting greater than that of the incremental job so that the Full does not expire before the Incremental has expired.
B) Back up the SQL databases in a separate job from the user databases.
Issue/Introduction
When the system databases are automatically switched to a full backup method during an incremental backup job, it removes the dependency on the prior backups from the associated user database backup set. Since the prior full and incremental backups are no longer part of the dependency chain, they can be deleted if the retention period expires before the depending incremental backups.
Additional Information
ETrack: 3916580
Was this article helpful?
thumb_up
Yes
thumb_down
No