Progress
Database Administration
Guide and Reference


Database Restore Examples

This section includes examples of database restores using PROREST for UNIX and Windows.

UNIX Full Backup Restore Example

The database administrator of Company X’s Development department wants to restore the devel.db database that was previously backed up.

Follow these steps to restore the devel.db database to a new database from a full backup:

  1. Enter the following command:
  2. prorest newdev /dev/rrm/0m 
    

    The newdev.db database is an empty database. The 9-track tape drive (/dev/rrm/0m) specifies the device from which the full backup is being restored. As the restore begins, the following report appears:

    This is a full backup of /usr1/develop/devel.db. (6759) 
    This backup was taken Wed Nov 18 15:34:43 1999. (6760) 
    The blocksize is 1024. (6990) 
    It will require a minimum of 3065 blocks to restore. (6763) 
    Read 41 blocks in 00:00:02 
    

    This command restores the database devel.db from a tape to newdev.db. The report indicates that volume 1 is being processed.

  3. Use newdev.db with Progress once the restore is complete.
UNIX Incremental Backup Restore Example

If you want to restore an incremental backup of the devel.db database to a new database, you must first restore a full backup, then follow these steps:

  1. Enter the following command to run an incremental restore of the database from a tape once the full restore is done:
  2. prorest newdev /dev/rrm/0m 
    

    The following report appears as the restore begins:

    This is an incremental backup of /usr1/develop/devel.db. (6759) 
    This backup was taken Wed Nov 18 15:41:47 1999. (6760) 
    The blocksize is 1024. (6990) 
    It is based on the full backup of Wed Nov 18 15:34:43 1999. (6761) 
    It will require a minimum of 3065 blocks to restore. (6763) 
    Read 41 blocks in 00:00:00 
    

  3. Once the restore is complete, use newdev.db with Progress.
Windows Full Backup Restore Example

The database administrator of Company X’s development department wants to restore the devel.db database.

Follow these steps to restore the devel.db database to a new database from a full backup:

  1. Enter the following command:
  2. prorest newdev d:\devback 
    

    The newdev.db database is an empty database. The name of the device is d: and \devback specifies the file from which the full backup is being restored. As the restore begins, the following report appears:

    This is a full backup of d:\deve1.db. (6759) 
    This backup was taken Wed Nov 18 15:56:28 1999. (6760) 
    The blocksize is 4096. (6994) 
    It will require a minimum of 1337 blocks to restore. (6763) 
    Read 1274 blocks in 00:00:02 
    

    This command restores the database devel.db from a diskette to newdev.db. The report indicates that volume 1 is being processed.

  3. Once the restore is complete, use newdev.db with Progress.
Windows Incremental Backup Restore Example

If you want to restore an incremental backup of the devel.db database to a new database, you must first restore a full backup, then follow these steps:

  1. Enter the following command to run an incremental restore of the database from a tape once the full restore is complete:
  2. prorest newdev e:\devback1 
    

    The newdev.db database is an empty database. The name of the device is a: and \devback specifies the file from which the full backup is being restored. As the restore begins, the following report appears:

    This is an incremental backup of D:\deve1.db. (6759) 
    This backup was taken Wed Nov 18 15:56:28 1999. (6760) 
    The blocksize is 4096. (6994) 
    It is based on the full backup of Wed Nov 18 15:56:28 1999 (6761) 
    It will require a minimum of 1337 blocks to restore. (6763) 
    Read 1274 blocks in 00:00:02 
    

  3. Once the restore is complete, use newdev.db with Progress.

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