4

When I attach a database file from SQL Server 2000 Standard Edition to SQL Server 2000 Database on another machine , I am receive the following error.

"Error 5172: The heather for file 'D:...' is not a valid database file header.
 The PageAudit property is incorrect."

I can not transfer data.What should I do?

Improve this question
4
  • Your DB files may have become corrupt. Do you have a backup of the DB?
    – StanleyJohns
    Commented May 11, 2011 at 17:40
  • @Stan the DBA - I don't have any backup of my database.
    – Cell-o
    Commented May 11, 2011 at 17:44
  • 2
    Are you still able to attach it on the original server and create a backup file?
    – RThomas
    Commented May 11, 2011 at 18:04
  • 2
    Did you check the SQL Server levels of the source and destination? If the original source database server is a higher patch level than the destination, it might cause problems like this....
    – Peter Schofield
    Commented May 11, 2011 at 18:06

1 Answer 1

Reset to default
4

The file's corrupt. You either need a backup, or you need to engage with a consultant who can try manually editing the file. (I'm not one of those consultants, and they're not cheap - you're in five-figure territory.)

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.