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

[Former Member]

Hello All

While restoring the DB,  I have got the following error message in SQL Server Management Studio

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

Screen shot is also attached over here...

Please guide me on the same.

Thanks

Praful

[KennedyT21 · Accepted solution]

Hi  Praful Rajyaguru ....

  I had the same problem. Here was my solution. 

1. When you make the backup, change the Backup Set Name.

2. Remove all of the destinations listed, and add 1 new destination.

3. Do a full backup.

It should restore normally.

If you check the contents of the backup when you go to restore it, if it says it contains 2 media families, you will probably have this problem.  I'm no expert, but this worked for me.

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/abf50e00-c9b0-4809-9e61-43ed8a53e968/

Regards

Kennedy

[KennedyT21]

Hi  Praful Rajyaguru...

Have you checked the above solutions, does the issue solved or not if not pls ask your questions

if solved pls close the thread with correct or helpful answers

Regards,

Kennedy

[kothandaraman_nagarajan]

Hi,

Please refer below link:

http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/6bfe2a42-912e-44be-b103-e77...

Thanks &  Regards,

Nagarajan