The media set has 2 media families but only 1 are provided. All members must be provided.

今天在恢复一sql server 2008数据库时遇到如下错误，

The media set has 2 media families but only 1 are provided. All members must be provided.

下面是该问题的解决方案，

Issue

While attempting to restore your database using MyLittle Backup you receive the following error:

   
   

    
    
     
     

      
      
The media set has 2 media families but only 1 are provided. All members must be provided.
     
     
   
   

Cause

This error is due to your backup being divided into more than one part at the time of creating your initial backup file. The backup will need to be repeated so that it is contained in one file only.

In the example screenshot below you will see that there are two paths listed for the backup destination, which will create a backup over two files.

Resolution

Remove one path from the backup destination so that only one .bak file is created and then restore this file using MyLittleBackup.

原帖： http://www.net24.co.nz/kb/article/AA-00125/17/Microsoft-SQL-Server-Hosting/MyLittle-Backup-Restore-Error-The-media-set-has-2-media-families-but-only-1-are-provided.html