HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

Sql 2000 attach Error 5172

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
2000error5172sqlattach

Problem

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?

Solution

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

Context

StackExchange Database Administrators Q#2655, answer score: 4

Revisions (0)

No revisions yet.