Database Verification

Use sp_iqcheckdb for database verification.

Check the consistency of your database as soon as possible after the server restarts following an abnormal termination, such as a power failure, and before performing a backup of the database.

You can use the sp_iqcheckdb stored procedure to detect and repair database consistency problems.

• The sp_iqcheckdb Stored Procedure
  The IQ Database Consistency Checker (DBCC) performs database verification. The sp_iqcheckdb stored procedure, in conjunction with server startup options, is the interface to DBCC.
• sp_iqcheckdb Output
  The output of sp_iqcheckdb consists of an extensive list of statistics and any errors reported by DBCC.
• Resource Issues Running sp_iqcheckdb
  sp_iqcheckdb reports resource issues encountered while executing.