15. Performing Backup and Recovery : Data Verification Before Backup : Methods of Verifying Data Accessibility
 
Share this page                  
Methods of Verifying Data Accessibility
One method of verifying the accessibility of your tables is to write a script that automatically checks each table and system catalog in your database.
Otherwise, you can use one of the following suggested methods:
Modify system tables to predetermined storage structures using the sysmod command.
Modify user table storage structures using the modify command.
Use any procedure that affects all the rows that are being backed up in each table. (For example, select all the rows from the tables.)
If rows in a table are not accessible, you receive an error message. If this happens, restore the table from an earlier checkpoint before doing a new backup.
Check the integrity of specific tables using the verifydb -mreport -otable tablename command.
For more information on these commands, see the Command Reference Guide.