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?

  • Your DB files may have become corrupt. Do you have a backup of the DB? – StanleyJohns May 11 '11 at 17:40
  • @Stan the DBA - I don't have any backup of my database. – Cell-o May 11 '11 at 17:44
  • 2
    Are you still able to attach it on the original server and create a backup file? – RThomas May 11 '11 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 May 11 '11 at 18:06

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.)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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