Competition: What’s your favorite Redgate tool? Enter now.

differentials

rbvdbergrbvdberg Posts: 14
edited January 4, 2010 10:24AM in SQL Backup Previous Versions
Is it possible to merge a differential backup into a full backup using SQLBackup? The reason I ask is that we have to keep 7 days of backups on disk. Using differentials, this means 1 full and 6 differentials. After day 7, I would like to merge the full and the oldest so I can keep on making only differentials. Without a "merge" function, we'd have to make another full and keep the old one for another week.

Comments

  • Hi there,

    As far as I am aware, this isn't possible. You do need to take another full backup and then the next 6 differentials.

    As a workaround, you may want to set up a scheduled job which copies the old backup files across to a network location, and which then also erases the old backup files on local disk thus ensuring you only ever have 7 backups on local disk.

    Pete
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
Sign In or Register to comment.