Validate button

Click the Validate button to run a Standard or Full validation check on all of the database tables and indexes in the selected database.

Standard	The Standard validation option lets the administrator validate the indexes and keys on all of the tables in the database. Each table is scanned, and, for each row, a check is made that it exists in the appropriate indexes. The number of rows in the table must match the number of entries in the index. The equivalent command is `nbdb_admin -validate`
Full	In addition to the Standard validation checks, a Full validation ensures that every row referenced in each index actually exists in the corresponding table. For foreign key indexes, it also ensures that the corresponding row exists in the primary table. The equivalent command is `nbdb_admin -validate -full`

These database validation checks do not require that all NetBackup activity be suspended. However, the validation checks may report transient errors that are a result of transactions that are in progress.

After running a validation check, the Results screen appears, listing each database object. Each error is listed next to the database object where it was found. The total number of errors found are listed at the end of the list of database objects. If no errors were found, that is indicated.

If any validation errors are reported, shut down the NetBackup daemons and services, and start only the SQL Anywhere database server. Then, repeat the validation check by clicking Validate button or by using the nbdb_admin command line utility.

If validation errors persist, contact Symantec customer support. The administrator may be asked to rebuild the database using the Rebuild button option or the nbdb_unload command line utility.

Related topic