I started working recently with sql server after years of working with Access. The SQL database will be written to, read from, and backed up mostly from a C# desktop application. I'm in the process of running through some trial backups, using BACKUP DATABASE [C:\Data\Data.mdf] TO DISK ='C:\Backup\DATA.BAK' and found that each full backup seems to added (in terms of file size) to the full backup before it, so that DATA.BAK just doubles in size when I write sequential full backups to that location. Is there an option to OVERWRITE the previous backup?
Also, if I use the previous statement, but throw in 'WITH DIFFERENTIAL', how does that work? When I did it, the differential seemed to be saved to DATA,BAK, but I thought it was supposed to be saved to a different file? As you can see, I am new to SQL Server, so any advice would be appreciated.
Oh, the C:\Backup\DATA.BAK is just an example. The actual path would be specified by the software user and would presumably be a network or external drive location. Also, my plan is to have a full backup saved weekly, but a differential created daily (or more than daily) automatically by the software.