Backing up files

Scenario – SQL Server backs up data files every night at 11 pm to the D drive, and at 2 am these are copied to a backup device (shows up as E drive). This backup device uses 3 cartridges that are swapped every night.

Problem – how to keep backup device from filling up with too many backups (each is about 1/2 gig and the cartridges hold about 40 gig.)

Solution – Since there are 3 cartridges, I created a batch file to delete the backup files from the D drive every 4 days at 10 pm. I then created a batch file to delete the backups from the cartridges every 7 days.

Advertisements

Posted August 15, 2008 by mmdmurphy in backups and recovery, freeware, sbs2003, tips, windows

Tagged with

%d bloggers like this: