Show TOC

Procedure documentationValidating the Database

Procedure

Validating a database is often one of the first steps in troubleshooting since it is a quick and easy way to tell if the database is corrupt. The simplest way to validate a database or table is to use a database application such as SQL Central.

  1. Click the right mouse button on the object within the “Sybase Central” window that you wish to validate. You can choose to validate an entire database [backoff.db (dba) or journal.db (dba)] or a single table.

  2. In the drop-down list, click Validate.

  3. When the validation process is finished, a message appears. If the table or database has passed validation, the message box reads ‘No Errors Reported’.