restore failed error
System.data.sqlclient.sqlerror : the media set has 2 media families but only 1 are provided. all member must be provided.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Jul 8, 2013, 4:12 AM
hi,
This error message means that the original back was taken as a striped backup where backup stream was spilt into multiple destination files (two or more).
Please refer
http://chiragrdarji.wordpress.com/2008/02/15/the-media-set-has-2-media-families-but-only-1-are-provided/
hope this will help you.
Iftikar HussainPosted Jul 8, 2013, 3:00 AM
Please check the below link
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/abf50e00-c9b0-4809-9e61-43ed8a53e968/the-media-set-has-2-media-families-but-only-1-are-provided
http://beyondrelational.com/modules/1/justlearned/0/tips/8659/sql-server-backup-database-into-multiple-files-and-restore-from-multiple-files.aspx
Regards,
Iftikar