Progress
Database Administration
Guide and Reference


Incremental Backup Example

This example shows how to use several of the incremental backup parameters. Because Windows limits you to nine tokens per command, you cannot use all the parameters with the PROBKUP command. If you want to use all the available parameters, run the backup in a procedure file.

When choosing the parameters, consider that the backup takes significantly longer when you use the -com or -red parameters. If you use the -red parameter, the backup also uses more backup media.

Follow these steps to perform an incremental offline backup of the devel.db database. To perform an online backup, skip Steps 2 through 4:

  1. Prepare the backup diskettes according to the operating system documentation.
  2. Verify that the database is not in use by entering the following command:
  3. proutil devel -C BUSY 
    

  4. Shut down the devel.db database by entering the following command:
  5. proshut devel 
    

  6. Run PROBKUP -estimate to determine how much media is necessary for the backup:
  7. probkup devel -estimate 
    

  8. Enter the following command to perform an incremental offline database backup:
  9. probkup devel d:\devback1 incremental -bf 20 -io 1 
    

    Enter the following command to perform an incremental online database backup:

    probkup online devel d:\devback1 incremental -io 1 -com 
    

    NOTE: You cannot use the -scan parameter for online backups.

    These are the arguments and parameters for the commands:

    devel

    Identifies the name of the database you are backing up.

    online

    Specifies that the backup is an online backup.

    a:\devback

    Specifies the output destination is a file, \devback, on the a: drive.

    incremental

    Specifies that the backup is an incremental backup.

    -bf 20

    Specifies that the blocking factor is 20 to match the blocking factor of the disk drive.

    -io 1

    Specifies that you can lose one incremental backup and still be able to restore the database.

    -com

    Indicates that the data should be compressed before it is written to the disk drive. If you specify the -com parameter and do not use -scan, PROBKUP displays the number of blocks and the amount of backup required for an uncompressed database.

    As the incremental offline backup of devel.db executes, the following report appears:

    The bi file requires a total of 64 blocks of backup media. 
    sales requires an unknown amount of blocks for backup media. 
    An unknown number of volumes are required. 
    Backed up 77 blocks in 00:00:01. 
    Wrote a total of 4 backup blocks using 82944 bytes of media. 
    Backup complete. 
    

    Because you did not specify the -scan parameter, Progress does not scan the database before beginning the backup, and therefore cannot determine how many blocks will be backed up. The number of backup blocks is the number of -bf units written to the tape. Backup blocks contain data, primary recovery (BI), and error-correction blocks.

    As the incremental online backup of devel.db executes, the following report appears:

    Incremental backup started. 
    Backed up 70 blocks in 00:00:01. 
    Wrote a total of 3 backup blocks using 103424 bytes of media.  
    Backup complete. 
    

  10. If you have after-imaging enabled, back up the AI files to a separate disk using a separate operating system backup utility.

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