Post reply

Restore .dat

  • 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

  • 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'

  • September 20, 2006 at 8:38 am

    #661515

    I'm using the Enterprise Manager.

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

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply