Correct a consistency check SQL failure

Before you begin

If a database consistency check fails due to a SQL error, PolicyCenter adds the following icons to the Server Tools Consistency Checks screen:
  • Download Errors
  • Rerun

Procedure

  1. In the PolicyCenter Server Tools Consistency Checks screen, click Download Errors next to the check that generated the error.
  2. Open the error report:
    1. Click the number in the With Errors column.
    2. On the details report that opens, click Details.
    3. Review the SQL query that generated the error.
    4. Correct any identified errors.

      The listed table name indicates the object against which the consistency check ran. The check name indicates which consistency check actually generated the error.

  3. In the PolicyCenter Server Tools Consistency Checks screen, click Rerun next to the consistency check that generated the SQL error.

What to do next

See also