I have a maintenance plan set up for my data base to back up on a nightly basis. I have it set to if file exists to append the file. I was always under the impression that appending the file just meant to change the data that has changed and to keep a record of past backups. But today I took a look at my backup file to see that it was over 100gigs. The Database that I am backing up is only 9 gigs.
What I am trying to do is to always have a couple days of backups on hand so in the unforeseen case that something happens when I am doing a backup. However, I do not have room to hold a 100 gigs worth of backup data. Should I be just doing an overwrite of the backup file if exists? If so what is the best way to make sure that I always have a couple days worth of Data.