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 |