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.

StepsRunning sp_iqcheckdb

  1. Start version 12.6 or 12.7 and connect to your database.

  2. Issue a CHECKPOINT command.

  3. 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
    
  4. Issue a COMMIT statement.

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

NoteFor 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.