Restore .dat in SQL Server 2000

  • 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

  • what is the 'D:\AHD_Nuevo.dat' ?

    in case it is sql server BACKUP file:

    is it located on Tape (as per error above)? or it is on Server Drive?

    if it is on Tape - can you restore it on local server drive - and the n from EM to restore it?

  • You need to give us more information on what you are attempting to do and what type of file you have. I once got a db backup from a company and was asked to restore it into one of our SQL Servers. I got this exact message. Come to find out the FTP transfer had messed up some of the bytes in the file and caused this message.

  • 'D:\AHD_Nuevo.dat' is a backup that has done using SQL Server 7. Now I have SQL Server 2000.

    The .dat is in Server Drive.

  • Try backing up the db again to a new file and then try the restore. i think the file is somehow corrupt.

Viewing 5 posts - 1 through 4 (of 4 total)

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