Backup Sets containing SQL database backups may expire prematurely.
Article ID: 100033941
Updated On:
Description
Backup Sets containing SQL database backups may expire prematurely.
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
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
