Shulou(Shulou.com)06/01 Report--

Fault description

MSSQL Server 2000 attach database error 823, attach database failed. There is no backup of the database, the database can not be restored through backup, there is an urgent need to restore the data in the database.

Second, fault analysis

The reason for the SQL Server database 823 error is that the physical page of the database is corrupted, sometimes the page has but the check value is damaged, so that the page cannot be recognized, or the 823 error may be reported if the page is lost due to power outage or file system problems.

III. Recovery process

1 try to attach the database, and then repair the database

Figure 1:

2 use the North Asia MSSQL file detection tool to detect the database

Figure 2:

3 calculate and modify the check value of the database error data page

4 reattach the database. Attach the database successfully.

Figure 3:

5 dbcc testing database

Figure 4:

6 fix the above errors and check the database by dbcc again

Figure 5:

IV. Results

The error of SQL Server database is solved perfectly, the database can be attached normally, it is complete through dbcc test, and the data is completely recovered.

Figure 6:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.