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.