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.
In the left pane of Sybase Central, select the database.
From the File menu, choose Validate Database
The Validate Database wizard appears.
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:
Execute the sa_validate stored procedure:
The procedure returns a single column, named Messages. If all tables are valid, the column contains
No errors detected.
For more information, see sa_validate system procedure.
Run the dbvalid utility:
dbvalid -c "connection-string"
If you are checking the validity of a backup copy, you should run the database in read-only mode so that it is not modified in any way. You can only do this when there were no transactions in progress during the backup. See -r server option.