SQL 2008R2 system table corruption

a customer unit, a running server suddenly failed to enter the system, there are running UF database, after the failure of their own company DBAs and OPS have been in the system for almost a week. The discovery database has not been used properly, and all previous June backup is damaged, the most recent backup is only April 30, asked what has been done over there, the customer has been described unclear, helpless can only let customers send the library to see, Customer is UF U8 database running platform for 2008R2.

Corruption of data MDF file found a lot of physical page corruption, the first to directly rebuild the log DBCC detection, after the 2008R2 platform reconstruction log found that DBCC statements can not query and run, direct error

Msg 8921, Level 16, State 1, line 1th
The check has been terminated. An error was detected while collecting the fact data. The tempdb space may be exhausted or a system table is inconsistent. Please check the previous error message.

 &NBSP, checktable (Xx,repair_allow_data_loss), but the damage to the table found that repair statements still error can not be fixed, the error result is: Repair failure    to fix this error, fix the other errors first.

generally for the table on the page maybe the system table is confused or damaged, we can learn from Baidu a repair system table post: Span style= "MARGIN:0PX;PADDING:0PX;FONT-FAMILY:TAHOMA;FONT-SIZE:11PT;" >http://wenku.baidu.com/link?url=hjukdgsfmeeb-_fxsjouukx7xuvic_ Kf2tlisi7cgg8sicwmmzh3tnumfv7jqhuw-1wa1-2cp5-eeno_kertusqv2lcurkwiopeoyqqyj-y

This method is too cumbersome, and the final study finds that the repair can be performed successfully by modifying the other parameters directly after the DBCC statement repair.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/D2/wKiom1WJBEWhXXwjAARhhj52h0M223.jpg "title=" 1245. JPG "alt=" wkiom1wjbewhxxwjaarhhj52h0m223.jpg "/>

Finally again the DBCC library detection found all OK no data error!

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6E/D2/wKiom1WJBFzR3pnyAALB4AN7U_k308.jpg "title=" 12389. PNG "alt=" wkiom1wjbfzr3pnyaalb4an7u_k308.jpg "/>

This article is from the "sqlrecovery" blog, make sure to keep this source http://sqlrecovery.blog.51cto.com/9576880/1664540

SQL 2008R2 system table corruption