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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-07 : 12:09:56
|
| Neil writes "I am having a problem restoring a database to the same server that it was backedup from. I am getting the message "The media set for database xxx has 3 family members but only 1 are provided. All members must be provided. Restore database is terminating abnormally.having look at Microsofts suppot pages I can't see why this error would occur, or what would cause it. The only thing I can think of is that after the original backup was taken the .bak file was zipped with Winzip9 to save space. It was unzipped using Winzip9 before I tried the restore. Any ideas gratefully received RegardsNeil" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-07 : 12:19:03
|
| Run:RESTORE HEADERONLY FROM DISK = 'file.bak' and see what that tells you.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Restore Problem SQL2000