Post reply

Error 3242 Microsoft tape format not

  • July 6, 2007 at 7:21 am

    #117248

    Bye,

    I had a anomaly during the commit of a vud file on vhd file. In practice my sql server 2000 virtual machine hasn't the last modifies.

    Using a recovery files software I found the last backup of manteinance plan of the day before crash, and I would restore these ones.

    I copied all .bak files in the same path where manteinance plan saved the scheduled backup, but during restoring I have this error:

    Error 3242 ....Microsoft Tape Format not valid ( SQL-DMODBC 4200)

    I tried all known commands:

    restore database ....

    restore filelistonly.....

    restore headeronly....

    restore verifyonly.....

    etc...etc...

    How can i recover my backups?

    Thanks

  • July 9, 2007 at 12:14 am

    #717925

    Try these links anyone might help you.

    http://support.microsoft.com/kb/905616

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=575666&SiteID=1

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 9, 2007 at 1:29 am

    #717940

    Thanks for your replay, but two links doesn't help me. My scheduled backup are made on device, and not on tape.

    I recovered all backup of the day before crash.... I'm talking about of a sql server virtual machine are not made the commit during shutdown....This is my really problem.....

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

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