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.
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.
Thanks a lot, it helps me.
ReplyDeletewhat about already created backup files?
ReplyDeletei know about this post but what about already created back file
ReplyDeletei want to restore already created back file