Check the consistency of your database as soon as possible after the server restarts following an abnormal termination, such as a power failure. Database consistency should also be checked before performing a backup of the database. In both of these cases, you can use the sp_iqcheckdb stored procedure to detect and repair database consistency problems.
This section describes using sp_iqcheckdb for database verification. The section “Database repair” contains details on using sp_iqcheckdb to repair the consistency problems detected.
