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. See -r dbeng12/dbsrv12 server option.
Check the validity of an entire database (Sybase Central)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.
Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA or VALID authority.
In the left pane, select the database.
In the File menu, click Validate Database.
Follow the instructions in the Validate Database Wizard.
You can also access the Validate Database Wizard from within Sybase Central using any of the following methods:
Right-clicking the database, and clicking Validate Database.
Selecting the database, and clicking Tools » SQL Anywhere 12 » Validate Database.
Check the validity of an entire database (SQL)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.
Connect to the database as a user with DBA or VALID 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.
Check the validity of an entire database (command line)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.
Run the dbvalid utility:
dbvalid -c "connection-string" |
Connect to the database as a user with DBA or VALID authority.
Check the validity of an entire database (Interactive SQL)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.
Connect to the database as a user with DBA or VALID authority.
Execute the VALIDATE DATABASE statement.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |