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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Error restoring database

Author  Topic 

sql_learner
Starting Member

7 Posts

Posted - 2004-06-06 : 22:34:06
Dear All,

I was trying to restore a .BAK file data that was sent by my co-worker. First I created a database, then use EM to restore the .BAK file to that database. However, It ended up with this error:

quote:
The media set for database 'db_name' has 2 family members but only 1 are provided. All must be provided. RESTORE DATABASE is terminated abnormally


Please help...

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-06-06 : 23:15:42
He needs to send you the other .bak file. ???

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

sql_learner
Starting Member

7 Posts

Posted - 2004-06-06 : 23:18:45
Thanks derrickleggett. However, this is the only .BAK file that is left (The db server was cleaned). Please help...
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-06-06 : 23:29:48
Somewhere.....over the rainbow..............................................

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -