Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Backup and Data Recovery » Backup and recovery tasks

Making an incremental backup Next Page

Validating a database

Validating a database is a key part of the backup operation. You must have either DBA or VALIDATE authority to validate a database.

Validation requires exclusive access to each table in turn. For this reason, it is best to validate when there is no other activity on the database.


Validating a table or an entire database should be performed while no connections are making changes to the database; otherwise, spurious errors may be reported indicating some form of database corruption even though no corruption actually exists.

To check the validity of an entire database (Sybase Central)
  1. In the left pane of Sybase Central, select the database.

  2. From the File menu, choose Validate Database

    The Validate Database wizard appears.

  3. Follow the instructions in the wizard.

    A message box indicates whether the database is valid or not.


You can also access the Validate Database wizard from within Sybase Central using any of the following methods:

  • Right-clicking the database, and choosing Validate Database from the popup menu.

  • Selecting a database, and choosing Validate Database from the File menu.

To check the validity of an entire database (SQL)