Kbase P17030: How to perform a Progress restore of a database which has a BI greater than 2 gigabytes in Progress
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/07/2009 |
|
Status: Verified
GOAL:
How to perform a Progress restore of a database with a BI file greater than 2 Gig in Progress 9.1C or later
GOAL:
Can prorest restore a large file enabled database?
FACT(s) (Environment):
Progress 9.1C
Progress 9.1D
All Supported Operating Systems
FIX:
In a situation where you need to restore a backup and you are aware that the BI file contained within the Progress backup is larger than 2 gigabytes you will need to create a structure file that defines sufficient space to hold the entire BI file.
Even if large file support was enabled for the original database which was backed up the prorest command process will not be aware of that until the restore is completed.
Sufficient planning for space allocation of the data and before image information, such as from a well defined .st file, is necessary before initiating the prorest otherwise the prorest will fail.
Enough space must be defined in the .st to encompass all the data in the database.
All of the storage areas which existed in the original database must be represented in the new .st file.
Each area defined in the new .st file must have enough space defined to hold the data in the corresponding area of the original database.
After the structure file is created you can give the normal command to perform a Progress restore:
prorest <database name> <device or file name>