Progress
Database Administration
Guide and Reference


Testing Backups

Test backups regularly to ensure they are valid and available when you need them. Be sure to test the backup before you need it to restore a database. Ideally, you should test the backup immediately after you perform it. Then, if there are problems with the backup, you can make another backup copy. If you wait until you need the backup to test it, the database will no longer be available.

Table 7–1 lists the Progress Restore (PROREST) utility parameters you can use to test backups performed with PROBKUP.

Table 7–1: PROREST Utility Verification Parameters 
Parameter
Description
-vp
Specifies that the restore utility read the backup volumes, and compute and compare the backup block cyclic redundancy checks (CRCs) with those in the block headers. To recover any data from a bad block, you must have specified a redundancy factor when you performed the database backup. See the "CRC Codes and Redundancy In Backup Recovery" section for more information about error correction blocks and data recovery.
You can use the Partial Verify parameter with both online and offline backups.
-vf
Specifies that the PROREST utility will compare the backup block-for-block to the database.

The Partial Verify and Full Verify parameters do not restore or alter the database.

For more information, see the description of the PROREST utility in Database Administration Utilities."

If you use an operating system utility to back up the database, with each backup, verify that you have backed up the entire database. The PROBKUP utility automatically backs up the appropriate files; with an operating system utility, you must make sure the files are included in the backup.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095