roblew 15918 (3/23/2015)
Just hit a issue where we had a 40gb backup file for a database with an mdf of less than 2gb and tran log less than half a gb.
Noticed someone had set the backup for this database to append the backup file in stead of overwrite it.
Just wondering why would you want to append a backup instead of overwrite it?
If you overwrite a backup
1) you cannot restore data from a previous backup after it gets overwritten with updated rows
2) you can save space
3) you have no backup left to restore data if you are overwriting a previous backup and the backup fails
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams