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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database maintenance » Database validation


Validating a database (command line)

You can validate a database using the command line.


You must have the VALIDATE ANY OBJECT system privilege. 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, errors may be reported indicating some form of database corruption even though no corruption actually exists.

Context and remarks

If you are checking the validity of a backup copy, run the database in read-only mode so that it is not modified in any way. You can only do this if there were no transactions in progress during the backup.

  • Run the dbvalid utility:

    dbvalid -c "connection-string"


The database is validated.

 See also