Database Repair

Allocation problems can be repaired by running sp_iqcheckdb in dropleaks mode.

If DBCC detects index inconsistencies while attempting allocation repair, an error is generated and allocation problems are not fixed.

• Analysis of Index Errors
  Use sp_iqcheckdb to analyze index inconsistencies.
• Index Error Repair
  Use the sp_iqrebuildindex procedure to repair an index, then run sp_iqcheckdb in verify mode to check for index inconsistencies.
• Analysis of Allocation Problems
  Use sp_iqcheckdb to analyze allocation problems.
• Repairing Allocation Problems using DBCC
  Use sp_iqcheckdb dropleaks to repair database allocation problems.