July 5, 2009 at 7:21 am
When Im restoring the database im getting following error
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.
How to solve above problem ,Plz give me solution urgent
July 5, 2009 at 9:58 am
The error message says the while backing up the database, more than one file names were specified which means the backup was stripped, meaning backup of the database were taken in more than one file.
Hence, while restoring the database, you must provide all the backup files instead of providing just one file.
July 5, 2009 at 10:03 am
The backup in question has been striped across two files, with half the backup in each one. This commonly happens by accident when backing up through management studio. If there are two files in the backup database dialog, the backup goes across both, not to theone selected.
The only way to resolve this is to find the other file. With only one of the two files, you only have half of the database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply