Data recovery case sharing: MSSQL 2000 Error 823

First, fault description

MSSQL Server 2000 attached database error 823, attaching the database failed. The database is not backed up, the database cannot be restored by backup, and data in the database is urgently needed.

Second, fault analysis
The cause of SQL Server database 823 error is generally: The database physical page is corrupted, sometimes the page has but the checksum value is corrupted, the page can not be recognized, it may also be due to power loss or file system problems appear missing page will also report this 823 error.

Iii. recovery process
1 Try attaching the database and then repairing the database
Figure One:

2 Testing the database using the North Asia MSSQL File Detection Tool
Figure II:

3 Calculating and modifying the checksum value of the database error data page
4 re-attaching the database, attaching the database successfully
Might

5 DBCC DETECTION database
Figure IV:

6 Fix the above error, once again DBCC detection database
Figure V:

Iv. Results
The SQL Server database 823 error is perfectly resolved, the database can be attached normally, complete with DBCC detection, and the data is fully recovered.
Figure VI:

Data recovery case sharing: MSSQL 2000 Error 823