I need to run a backup command on SQL Server 6.5, with the option to delete the backup files, older than 3 days. I'm running the command below:
dump database ABC
The above command is overwriting everytime it starts fresh. Is there a way to keep the backup which are 3 days older and still write to the same backup device?
Nope, not even in 2K. Instead look into SQLMAINT. Having 3 days worth of backups in 1 file is 3 times more dangerous than having them 1 in each individual file. In 6.5 the GUI gives you an erroneous warining about danger to run SQLMAINT against databases greater than 400MB, - just ignore it (as per M$ and 6 years of running it myself.)
I use a script for my 2000 databases that write a complete backup for each day of the week. We have a backup server with 7 drives with shares named for each day, which later get backed up to tape. Next week, the backups to disk are overwritten.
You're writing to an individual file until 7 days worth of backups are accumulated, after which you re-initialize the device. sqlserver2k is trying to append to the same backup device without completely overwriting it, but rather "push out" the 4-day-old backup from the file (did I understand it correctly?) As I said earlier, SQLMAINT with -DelBkUps will ensure that backups older than the specified number of days/weeks will be retained, and the rest - deleted.
On many of our servers we switched to SQLLiteSpeed (of course we already upgraded all our 6.5's, or rather the ones we care about, to 7.0 or 2K) and have a retention period on disk for up to a month, instead of 4 days max using SQLMAINT.