Restore DataBase Error from device

• Papillon

  Hall of Fame

  Points: 3303

  More actions

  August 10, 2006 at 10:54 pm

  #169917

  Hello friends,

   

  I have sql server 2005 Eterprise edition..i have taken one data base .bkp from another sql server 2005 server and try to restore it to my server but i am getting error like

  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.

  i m trying to restore from management studio express....

   

  please help me out.

  ---

  Regards,

  Papillon

• Elliott Berkihiser

  SSCarpal Tunnel

  Points: 4068

  More actions

  August 14, 2006 at 5:14 pm

  #654978

  Have you tried examining the backup file with these commands?

  restore filelistonly from disk='C:\MyFolder\Myfile.bkp'

  and

  restore headeronly from disk='C:\MyFolder\MyFile.bkp'

  The contents of that backup file my give you some clues as to how the restore must proceed.

  Elliott