March 23, 2015 at 5:06 am
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?
March 23, 2015 at 3:16 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy