Verify your databases

Run the 12.x version of sp_iqcheckdb to check the validity of your current databases. Make sure that the database is in a valid state and can start without requiring recovery.The 12.x versions of sp_iqcheckdb use input parameters, rather than database options, to specify the type of database consistency checking.

Running sp_iqcheckdb

Start version 12.6 or 12.7 and connect to your database.
Issue a CHECKPOINT command.
Run sp_iqcheckdb in verify mode.
```
sp_iqcheckdb 'verify database'
```
If you run the procedure from Interactive SQL, redirect output to a file by typing the following:
```
sp_iqcheckdb 'verify database' >& filename
```
Issue a COMMIT statement.

Examine the sp_iqcheckdb report for errors. Repair any index and allocation problems.

For information on interpreting the sp_iqcheckdb results and corrective action, refer to Chapter 13, “System Recovery and Database Repair,” in System Administration Guide: Volume 1. If you need to contact Sybase Technical Support, you must provide the output from sp_iqcheckdb.