Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
thendraljazz
Starting Member
26 Posts |
Posted - 2012-02-13 : 04:58:19
|
Hi While restoring database i got the following error..Error:the media set has 2 media families but only 1 are provided all members must be providedCan any one tell me the solution? |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-13 : 08:13:01
|
Solution is to take another backup or find the second file.What that's saying is that when the backup was taken it was striped over two files, so each file has half of the backup. This is sometimes done by accident when backing up with the SSMS gui. If there are two files listed in the destination text box, the backup will be striped across the two and you'll need both for the restore.--Gail ShawSQL Server MVP |
|
|
|
|
|