System Recovery and Database Repair

Learn about normal Sybase IQ server recovery, special recovery modes, how to verify database consistency, and how to repair database inconsistencies.

When you restart the database server, Sybase IQ attempts to recover automatically. If the server cannot recover and restart, especially after a system failure or power outage, the database may be inconsistent.

• Recovery and Repair Overview
  If your Sybase IQ server or database has problems restarting, use this information to diagnose database startup problems, verify the consistency of databases, and repair databases.
• Normal Recovery
  During system recovery, any uncommitted transactions are rolled back and any disk space used for old versions (snapshots of database pages that were being used by transactions that did not commit) returns to the pool of available space.
• Database Verification
  Use sp_iqcheckdb for database verification.
• Database Repair
  Allocation problems can be repaired by running sp_iqcheckdb in dropleaks mode.
• Forced Recovery Mode
  Forced database recovery differs from normal database recovery.
• Problems Reported by DBCC
  Messages are reported for problems that DBCC cannot repair.
• DBCC Error Messages
  These are the most important messages in the DBCC output.