MSSQL is Microsoft released a database management system, SQL Server is a scalable, high-performance, designed for distributed client/Server computing, database management system, has realized with the combination of WindowsNT, provide the enterprise information management system based on transaction scheme, are widely used in major areas,
fault condition
In the database using common database error is in the process of "MSSQL Server 2000 additional database error 823," additional database failure, at this time if the user is in the process of using the database backup habits on a regular basis, just restore the backup can, but if the user does not have the data backup, backup or time too long, lead to the latest data loss, or for other reasons lead to the backup data is used, it needs to be on a database for data recovery operation, today to introduce specific data recovery steps,
Analysis of the
Database error message is "823" is how to return a responsibility? Often appear this kind of error has the following three possibilities, the first is due to physical pages appear the damage of the database, the second is caused by the calibration value is damaged database pages cannot be identified, appeared at 823 errors, and the third is possible because of abnormal power outages, file system damage caused by the database page is missing, then in the database will also prompt the "823" error,
database recovery process
Additional database, first step: try to repair the database, we can see the image below, our database for additional prompt after "823" error,
Step 2: use north Asia MSSQL file detection tool to test the database
Step 3: calculate and modify data in the database error page check values
Step 4: to additional database, additional database success
Step 5: DBCC detection database
Step 6: fix the error, once again DBCC detection database
database restoration results
We once again tested DBCC database and found no errors, additional database, again without any error, additional database is successful, through normal database environment for database query, validation, finally can confirm all data are complete recovery, database restoration success,
