DBCC CHECKDB Repair command of SQL Server, which gets used mostly in repairing of MS SQL Server database, also depends upon few critical system tables to get a view about how the SQL Server database will look like and if those system tables themselves are corrupted then, DBCC CHECKDB Repair fails to get view about database and the recovery remains undone. Other issues of SQL corruption like damage in system tables, metadata corruption, etc are also critical issues of corruption, which cannot be repaired with DBCC CHECKDB Repair command of SQL Server.
Which Errors show Damage in ?
System table pre-checks: Object ID 4. Could not read and latch page (1:358) with latch type SH.
Check statement terminated due to unrepairable error.
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent.
These above mentioned are the error messages, which occur at times of damage in system tables, you may face errors similar to these errors at times of corruption in SQL Server database.
What not to do at times of Damage in System Tables of MS SQL Server Database?
1.You should not detach the database at times of corruption in SQL MDF file because detaching can make SQL Server database corruption more badly.
2.You should not restart MS SQL Server during corruption in MS SQL Server database because if SQL Server finds out corruption while restart-recovery on a database then, database can be marked as suspect and making necessary repair for it can be difficult.
3.You should not avoid integrity check command at times of corruption in MS SQL Server database because this integrity check helps in deciding the relevant method of recovery. If the database is larger in size then, this integrity check may take longer time in completion.
What to do to fix SQL Server Corruption if System Tables are damaged? In cases of damage in SQL Server system tables, when DBCC CHECKDB Repair fails to perform recovery of MS SQL Server database and , you can use SQL Recovery third party tool. Common issues of corruption in MS SQL Server database, which gets faced by maximum users, are corruption in non-clustered indexes, corruption in large object pages, metadata corruption, inaccurate space metadata corruption, etc and this tool can fix all of them without making changes in the information of database. Repairing of database of all MS SQL Server editions can be done with the help of this software.