sql server restoring back up error

backup sql-server-2012 database-backups sql-server-2012-express
danarj picture danarj · Apr 8, 2013 · Viewed 47.4k times · Source

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

Answer

SWalters picture SWalters · Apr 9, 2013

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.

Related questions

Backup and restore SQL Server database filegroup

I use sql server and have a huge database that partitioned by date in multiple file groups. the database filegroups is PRIMARY, FG2010, FG2011, FG2012, FG2013, and FG2014, that FG2010, FG2011, FG2012 and FG2013 is readonly. Now, the backup scenario …

Read More
SQL Server: Database stuck in "Restoring" state

I backed up a database: BACKUP DATABASE MyDatabase TO DISK = 'MyDatabase.bak' WITH INIT --overwrite existing And then tried to restore it: RESTORE DATABASE MyDatabase FROM DISK = 'MyDatabase.bak' WITH REPLACE --force restore over specified database And now the database …

Read More
Restore a postgres backup file using the command line?

I'm new to postgresql, and locally, I use pgadmin3. On the remote server, however, I have no such luxury. I've already created the backup of the database and copied it over, but, is there a way to restore a backup …

Read More