I'm implementing a very simple backup plan for a SQL database, and I was monkeying around with full backups. It seems that If I'm backing up to a hard disk, over the same file, that it doubles in size for every backup I run. I don't want the backup to add to the file, I want it to replace it. Obviously this will lead to storage size issues. Also, it's not an option (even though it would be best, I know), to move the backup to a different location or to a tape each time the backup runs.
So, finally, the question: How can I backup to the same file & location without appending to the existing file?
A point in the right direction would be very helpful. Thanks!
So, finally, the question: How can I backup to the same file & location without appending to the existing file?
A point in the right direction would be very helpful. Thanks!
