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.

See the section “Recovering leaked space” for specific information on recovering leaked blocks, (blocks that are allocated, but not used).