|
|
|
SSC Rookie
 
Group: General Forum Members
Last Login: Yesterday @ 10:14 PM
Points: 39,
Visits: 314
|
|
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
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 9:26 PM
Points: 1,698,
Visits: 2,268
|
|
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.
Pradeep Singh
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Yesterday @ 9:28 AM
Points: 14,526,
Visits: 10,415
|
|
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
We walk in the dark places no others will enter
We stand on the bridge and none may pass
|
|
|
|
