67

I have backed up a database I had created on an other machine running SQL server 2012 express edition and I wanted to restore it on my machine, which is running the same. I have ticked the checkbox overwriting existing one, and got this error:

Backup mediaset is not complete. Files: D:\question.bak. Family count:2. Missing family sequence number:1
danarj
  • 1,798
  • 7
  • 26
  • 54

3 Answers3

139

This happens if, when you made the backup, you had multiple files listed in the backup destination textbox. Go back to your source server and create the backup again; this time, make sure there's only one destination file listed.

If you had more than one file listed as the backup destination, the backup is striped across them; you'll need all the files to perform the restore.

You can verify this by performing a RESTORE LABELONLY against the single file you copied to your destination server.

SWalters
  • 3,615
  • 5
  • 30
  • 37
  • 18
    I'm thankful for the existence of human beings like you that (1) know what they're saying and (2) answer questions fully yet succinctly... (y) – Fernando Espinosa Sep 12 '13 at 20:28
7

Sandra Walter's Answer provides an accurate description of what has happened, but I found the answer a bit lacking.

To make a backup which isn't striped (which is what has occurred in this situation), go back to the window where you setup the backup of your database. At the bottom is a list of paths where the different stripes will go to.

Go to each of the listed paths and delete the stripe of the backup.

Then remove all but one of the paths from the list in the window. And click the "OK" button. Your unstriped backup will be created at that one path.

Hope that helps.

Community
  • 1
  • 1
ArtOfWarfare
  • 20,617
  • 19
  • 137
  • 193
1

My backup was scheduled on two different locations. once I selected both options during restoration its worked for me.

Hamid
  • 11
  • 1