error occured during database restore

Question

restore failed error System.data.sqlclient.sqlerror : the media set has 2 media families but only 1 are provided. all member must be provided.

Jignesh Trivedi · Answer

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 Hussain · Answer

Hi 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