problem in restoring a new databse .

• Kotamraju Nalini

  Grasshopper

  Points: 11

  More actions

  April 12, 2007 at 4:40 am

  #76688

  I have used ntbackup tool to store the backup file to the tape.

  then when i am trying to use the tape to restore database directly from tape

  use master

  restore database test

  from tape='\\.\tape0'

  Server: Msg 3143, Level 16, State 1, Line 2

  The data set on device '\\.\Tape0' is not a SQL Server backup set.

  Server: Msg 3013, Level 16, State 1, Line 2

  RESTORE DATABASE is terminating abnormally.

   

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  April 12, 2007 at 6:04 am

  #700024

  As the error states, SQL can only restore from tape backups made using SQL BACKUP, your backup was done using NTBACKUP and hence the error.

  Use NTBACKUP to restore the backup from tape to disk then RESTORE the database from the disk file

  Far away is close at hand in the images of elsewhere.
  Anon.