Restore .dat

• Lisset

  SSCommitted

  Points: 1858

  More actions

  September 19, 2006 at 1:13 pm

  #75064

  Hi,

  I want to restore the file AHD_Nuevo.dat, in the SQL Server 2000, but show me the follow message:

  Error 3242:The file on device 'D:\AHD_Nuevo.dat' is not a valid Microsoft Tape Format backup set. RESTORE FILELIST is terminating abnormally.

  Thanks by your help

• Sreejith Sreedharan

  SSCertifiable

  Points: 5403

  More actions

  September 19, 2006 at 3:09 pm

  #661371

  Can u show me the restore statement that you are trying to run?

  Here is how its done:

  RESTORE DATABASE DBName

   FROM DISK = '\\Path\Backupfile.dat'

• Lisset

  SSCommitted

  Points: 1858

  More actions

  September 20, 2006 at 8:38 am

  #661515

  I'm using the Enterprise Manager.

  Right-click Database->All Tasks->Restore Database