SQL Server Error. The media set contains 2 media families, but only 1

Question

SQL Server Error. The media set contains 2 media families, but only 1. I am trying to restore a 200 MB database in SQL 2008 and I am getting this error

"The media set contains 2 media families, but only 1 is provided. All members must be provided

Answer 1

You get this error because the database backup was interlaced and the backup stream was split into two destination files. You are trying to restore from a single backup file. You need both files to restore the database.

See here for more error information.

Answer 2

You have installed two backups! You can change it to one place when you want to backup. Sorry for my English.

Answer 3

This is an old question, but if someone comes here later (like me), this may help:

If you cannot restore the backup and you have both files, you can restore the database by going to Tasks > Restore > Database and clicking From Device .

Choosing Database in the menu is an important point. It seems to me impossible to restore a database divided into several files using the Files and Filegroups .

Thanks to Hamid Sirat's answer in the link posted earlier by ughai ( here ) for this solution.