We've recently started using differential backups along with our full backups on some of our database. I'm trying to grasp how retention works now that we've added differentials. Our backup policy (SQL_MC) is as follows:
verexists: 7
verdelete: 1
retextra: 60
retonly: 60
The include statement in dsm.opt is simply:
INCLUDE * SQL_MC
On one particular database server, we run full backups twice a week (Sunday and Wednesday). We also run three differentials per day.
Why do the full backups erase all prior differential backups? I'm not sure what we're doing wrong. We'd like to be able to restore any of the backups within the past 7 days.
verexists: 7
verdelete: 1
retextra: 60
retonly: 60
The include statement in dsm.opt is simply:
INCLUDE * SQL_MC
On one particular database server, we run full backups twice a week (Sunday and Wednesday). We also run three differentials per day.
Why do the full backups erase all prior differential backups? I'm not sure what we're doing wrong. We'd like to be able to restore any of the backups within the past 7 days.