debugsqlMinor
Sql 2000 attach Error 5172
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.
I can not transfer data.What should I do?
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.