choose append to existing backup instead of overwrite
Posted
by aron
on Stack Overflow
See other posts from Stack Overflow
or by aron
Published on 2010-05-28T13:55:10Z
Indexed on
2010/05/30
0:02 UTC
Read the original article
Hit count: 229
Hello, I have a database and I made it's first backup 2 days ago. Then yesterday I spent an entire adding new records. This morning I ran a backup, (but I selected append to existing backup set) as pictured below.
I just ran a restore and I found that it wiped out all my data from yesterday and it restored it from the backup of 2 days ago. Not the version from this mornings backup.
I zipped this backup file to be safe.
I changed some data in the DB, Then I ran the back up again, but this time I selected "overwrite all existing backup sets"
Now when I restore the db it's seems to restore the data from the backup correctly. I think I learned a lesson here, correctly if I'm wrong
My questions is, Did I lose an entire day of work?
I still have this morning's backup .bak file safe in a zip. Is there anyway I can restore is with the right data?
© Stack Overflow or respective owner