title: choose append to existing backup instead of overwrite
body: <p>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, <strong>(but I selected append to existing backup set)</strong> as pictured below.</p>
  
  <p>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. <strong>Not the version from this mornings backup.</strong></p>
  
  <p>I zipped this backup file to be safe.</p>
  
  <p>I changed some data in the DB, Then I ran the back up again, but this time I selected <strong>"overwrite all existing backup sets"</strong></p>
  
  <p>Now when I restore the db it's seems to restore the data from the backup <strong>correctly</strong>.
  <strong>I think I learned a lesson here, correctly if I'm wrong</strong></p>
  
  <p>My questions is, Did I lose an entire day of work?</p>
  
  <p>I still have this morning's backup .bak file safe in a zip.
  Is there anyway I can restore is with the right data?</p>
  
  <p><a href="http://img62.imageshack.us/img62/1934/backup1.gif" rel="nofollow noreferrer">alt text http://img62.imageshack.us/img62/1934/backup1.gif</a></p>