cannot attach database

  • Erorr - The header for file '%ls' is not a valid database file header. The %ls property is incorrect.

    can anybody help

  • Did you get the error exactly like that, with the %ls in it?

    I hope you have a backup. That kind of corruption isn't repairable and with a damaged file header there's no way that will reattach successfully.

    Just check and make sure that's not a SQL 2005 database you're trying to attach.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • You can always call Microsoft PSS and perhaps they can help you with getting some data, but we can't do anything with had header files.

  • Steve Jones - Editor (8/31/2008)


    You can always call Microsoft PSS and perhaps they can help you with getting some data

    They won't help with that. I helped out with an unrecoverable database (with bad file headers) earlier this year. We asked PSS if they could help with data recovery from the files and the answer was no.

    There are tools around that may get data back from damaged file. They aren't cheap and my experience with them is that they're not that good.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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