Friday 5 December 2014

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

I was trying to restore a SQL backup (.bak) file of NAV2013R2 and got this error message.



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

Msg 3132, Level 16, State 1, Line 1 
The media set has 2 media families but only 1 are provided. All members must be provided. 
Msg 3013, Level 16, State 1, Line 1 
RESTORE DATABASE is terminating abnormally.


I tried many ways but still got same error.

I tried to take backup again to check whether I can find anything strange.
I noticed having 2 Destination files added while taking backup.



This error is due to your backup being divided into more than one part at the time of creating your backup file.

Remove one path from the backup destination so that only one .bak file is created.
Now I was able to restore the backup file successfully.

3 comments:

  1. Thanks a lot, it helps me.

    ReplyDelete
  2. what about already created backup files?

    ReplyDelete
  3. i know about this post but what about already created back file
    i want to restore already created back file

    ReplyDelete