Kingdee 12.0 SQL Server database may have a schema corruption, run the DBCC checkcatalog bug fix

Customer Database error Contact us, our engineers get customer data, the database DBCC CHECKDB repair, reported "MSG 211, Level 23, State 51, line 1th

Schema corruption may have occurred. Please run DBCC CHECKCATALOG. ”

message 0 , Level - , the State 0 , the first 0 Line

A critical error has occurred with the current command. Any results that may result should be discarded.

The error is as follows:

It seems that the use of SQL Server itself can not be repaired, this error is usually a system table corruption, repair methods generally have the following two kinds:

The first approach is to use the database repair software to extract the data into a script and then rebuild the database. The advantage of this approach is not to spend too much manpower, the disadvantage is that the database is regenerated more or less a portion of the data, and because the rebuilt library has a view or stored procedures such as loss of the situation, so that the software can not directly invoke the database.

The second method is to manually fix the error message, keep the database structure "original", this repair method is laborious, but if the database is large, the use of the first repair method will take a long time, and manual repair in addition to the structure is not changed, the speed is sometimes much faster. There is no problem with repairing the database software calls.

The disadvantage is to be very clear about the database storage structure. Experienced engineers are required to hand-fix them in person.

Since this database is called Kingdee 12.0, is very important financial software, according to customer requirements is software must be able to call. Therefore, the second kind of repair scheme is adopted. After a day of analysis and repair by our engineers, we are very familiar with the storage structure of the database, and the final database repair of our self-developed recovery software is successful. Customers can call the software to be very satisfied with the recovery results!

Important Reminders

　　usually pay attention to database backup, once found the database file error: " schema corruption may have occurred. Please run DBCC CHECKCATALOG. " stop everything, please contact professional data company first time, do not fix it yourself, can reduce the risk of data loss.

Kingdee 12.0 SQL Server database may have a schema corruption, run the DBCC checkcatalog bug fix