ASA Database Administration Guide
Backup and Data Recovery
Backup and recovery tasks
Validating a database is a key part of the backup operation. For information, see Ensuring your database is valid.
For an overview of the backup operation, see Making a full backup.
To check the validity of an entire database (Sybase Central)
Connect to the database as a user with DBA authority.
Right-click the database and choose Validate Database from the popup menu.
Follow the instructions in the wizard.
A message box indicates whether the database is valid or not.
To check the validity of an entire database (SQL)
Connect to the database as a user with DBA authority.
Execute the sa_validate stored procedure:
call sa_validate
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.
To check the validity of an entire database (Command line)
Connect to the database as a user with DBA authority.
Run the dbvalid utility:
dbvalid -c "connection_string"
For more information, see The Validation utility.
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.
For information on running databases in read-only mode, see -r server option.