Post reply

Differential Backup

  • August 23, 2007 at 12:47 pm

    #118298

    Backup strategy:

    Full backup on Sundays. 4 sets kept

    Differential nightly Monday-Saturdays.

    I want to setup a job for differential backup which will function just like maintenance plan for full backup where it creates new file per day and older files are deleted let's say after 14 days.

    How can this be done with differential? If I create job using:

    BACKUP DATABASE NWIND

    TO DISK = 'C:\BACKUP\Nwind_Diff.bak'

    WITH DIFFERENTIAL

    This will append the backups to Nwind_diff.bak. My worry is how to restrict it to let's say 14 days so that on day fifteen it overwrites day 1's backup or some how create separate backup files that will be deleted after 14 days?

    Thanks in advance.

  • August 23, 2007 at 12:54 pm

    #729081

    Does your script overwrite existing file?

  • August 23, 2007 at 1:00 pm

    #729084

    Yes the one above does overwrite. However, I would like separate diff backup files created nightly and be deleted after 14 days.

    Any idea how?

  • August 30, 2007 at 9:54 pm

    #730648

    Hi,

    BACKUP DATABASE NWIND

    TO DISK = 'C:\BACKUP\Nwind_Diff.bak'

    WITH DIFFERENTIAL, retaindays=14

  • August 31, 2007 at 7:46 am

    #730772

    There are numerous scripts on this site that will write a new file based on the date. I'd recommend different dates since I've had issues iwth a single file before.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply