The media set has 2 media families but only 1 are 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"

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.

You can know more details about the issue from Microsoft PM who owns SQL backups

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?forum=sqltools

The solution was copied from the below link

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

Hope it helps you

Best Regards

Ahmed Gamal