We make a full online backup of our database on sunday.
After full backup we perform incremental delta backups
(3 backups a day).
Unfortunately it happens that one delta incremental
backup fails cause with following error code:
SQL2426N Incremental backup is not enabled for this database. Ensure that modification tracking is activated, and perform a full backup of this
The trackmod is activated and everything works fine a few days
or a few incremental backups.
Which event could make delta backups impossible?
The only solution for this is to make a full backup and go
on with deltas but I would like to know why this problem occurs.