Post reply

ERROR :3242

  • September 13, 2006 at 10:40 am

    #169684

    ERROR:3242 THE FILE ON DEVICE 'D:/MYDATA' IS NOT A VALID MICROSOFT TAPE FORMAT BACKUP SET. RESTORE FILELIST IS TERMINATION ABNORMALY.

     

    GIVE ERROR MSG WHILE RESTORING BACKUP

  • September 15, 2006 at 6:28 am

    #660662

     I have gotten this error before in SQL 2000 as well. The file is either corrupt or was transferred in an incorrect format that is no longer readable via SQL Server.

  • October 19, 2006 at 3:12 pm

    #666941

    Have u used virtual back up device and trying to restore db from that? If so.. check the status of the device if it is ok or broken...


    CDBA

  • December 14, 2006 at 5:53 am

    #678043

    Have you tried these options ???  Try either or both. You will be able to tell if SQL Server can read the backups at least. If it cannot read them then I think you are dead in the water. But, maybe MSFT can help. If the backups and getting the data is critical I'd call Microsoft.

     

    restore filelistonly from disk = 'c:\dbnamehere_db_200412081805.BAK'

     

    AND/OR

    restore verifyonly from disk....

  • December 14, 2006 at 1:04 pm

    #678188

     You should get an error stating it is not a microsoft backup file or something to that effect.

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

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