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:
- Enter the following command:
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 command restores the database
devel.db
from a tape tonewdev.db
. The report indicates that volume 1 is being processed.- 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:
- Enter the following command to run an incremental restore of the database from a tape once the full restore is done:
The following report appears as the restore begins:
- 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:
- Enter the following command:
The
newdev.db
database is an empty database. The name of the device isd:
and\devback
specifies the file from which the full backup is being restored. As the restore begins, the following report appears:
This command restores the database
devel.db
from a diskette tonewdev.db
. The report indicates that volume 1 is being processed.- 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:
- Enter the following command to run an incremental restore of the database from a tape once the full restore is complete:
The
newdev.db
database is an empty database. The name of the device isa:
and\devback
specifies the file from which the full backup is being restored. As the restore begins, the following report appears:
- 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 |