Checking Database Consistency

Check database consistency before backing up.

The sp_iqcheckdb procedure performs various functions, depending on the parameters specified.

The four modes for checking and repairing database consistency are described in Reference: Building Blocks, Tables, and Procedures > System Procedures > sp_iqcheckdb Procedure.

You may run sp_iqcheckdb on any multiplex node, but on a secondary server the procedure cannot access the freelist, so no freelist checks occur.

Start a multiplex coordinator single-node mode (-iqmpx_sn 1) to run sp_iqcheckdb dropleaks. You cannot run dropleaks mode on multiplex secondary nodes.