The sp_iqcheckdb procedure can perform several different functions, depending on the parameters specified. The four modes for checking and repairing database consistency are described in “sp_iqcheckdb procedure” in Chapter 7, “System Procedures,” in Reference: Building Blocks, Tables, and Procedures.
You may run sp_iqcheckdb on any multiplex node, but on a secondary server the procedure cannot access the freelist, so no freelist checks are performed.
Start a multiplex coordinator single-node mode (-iqmpx_sn 1) to run sp_iqcheckb dropleaks. You cannot run dropleaks mode on multiplex secondary nodes.
