Database file corruption may not be reported until the database server tries to access the affected part of the database. You can check that your database is valid by using Sybase Central.
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.
Use the SQL Anywhere 16 plug-in to connect to the database.
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 16 » Validate Database.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|