Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
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
add comment

1 Answer

up vote 2 down vote accepted

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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