Restore fails with error "The media set has 2 media families but only 1 are provided. All members must be provided."
Views (30515)
Mohana Yadav
61,005
Super User 2025 Season 2
Like
Share
ReportI 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.
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.
This was originally posted here.
*This post is locked for comments