SQL Server - system.data.sqlclient.sqlerror the media set has 2 media families but only 1 are provided

Asked By reenu Ch on 22-Jun-12 01:42 AM

When Restore Database into Sql Server 2008

I got this Error,

Restore Failed for server

 system.data.sqlclient.sqlerror the media set has 2 media families but only 1 are provided.All Members must ve Provided.

Sreenu. Ch
Vikram Singh Saini replied to reenu Ch on 22-Jun-12 10:29 PM
The cause of problem is:

When backup was done it was not a complete single file backup but it was striped backup i.e. backup was done in two files for performance issue. So when the backup is done, the first file (x) contains information that there is second file (y) which contains continuing backup of this file. And the second file(y) contains information that there is first file(x) which contains backup.

So whenever you try to restore the files to database it expects the second file to be there in same folder. Do check the backup file(s) in directory, which you are trying to restore. There would be a second file too.

Credit: The above idea has been picked from link http://social.msdn.microsoft.com/Forums/en/sqltools/thread/abf50e00-c9b0-4809-9e61-43ed8a53e968. And the link also contains six accepted solutions for very same problem. I hope that would help you in all.