Restore issue

• Reet

  Right there with Babe

  Points: 747

  More actions

  August 3, 2006 at 4:52 am

  #115007

  Hi,

  I'm trying to restore a db and get the following error:

  Microsoft SQL-DMO (ODBC SQLState: 42000)

  The media set for database '[db name]' has 2 family members but only 1 are provided. All members must be provided. BACKUP DATABASE is terminating abnormally.

  Can anyone suggest anything?

  many thanks

  Reet

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  August 3, 2006 at 5:05 am

  #653034

  Reet

  I've never seen this message before, but I'd guess that when the backup was taken, it was striped across two backup devices or files, and you only have one of them present.

  John

• Gerhard-307503

  Newbie

  Points: 1

  More actions

  August 4, 2006 at 12:43 am

  #653255

  You can try RESTORE LABELONLY. This should tell you if the media is striped.

  Syntax

  RESTORE LABELONLY

  FROM < backup_device >

  [ WITH { NOUNLOAD | UNLOAD } ]

      [ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]

  < backup_device > ::=

      {

          { 'logical_backup_device_name' | @logical_backup_device_name_var }

          | { DISK | TAPE } =

              { 'physical_backup_device_name' | @physical_backup_device_name_var }

      }