Database backup with OS utilities

« Go Back


EnvironmentProduct: Progress
Product: OpenEdge
Version: All supported versions
OS: All supported platforms
Question/Problem Description
Have a valid OS backup of your database
Make a database backup with OS utilities
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
A valid backup is a backup that will allow you to restore your database.

When using an OS utility (cpio, tar, ..) to backup your database then it is important that
. your database is shutdown and is not accessed by any single-user client all the time the backup takes place
. you do not miss any file of your database

The database files will be just a <dbname>.bi and <dbname>.db for Progress V8 (as well as V6 and V7) single volume database, but there are more files for any V9 database or for multi-volume databases.
For a multi-volume database, the command "prostrct list <dbname>" will give you the list of its files..

You will find in the "<database>.st" file the localization of:
<dbname>.b1,<dbname>.b2, ....<dbname>.bN [ Primary Recovery Area, also called Before Image file ]
<dbname>.d1, <dbname>.d2, ....<dbname>.dX [ Schema Area ]
<dbname>_7.d1, <dbname>_7.d2, ..... [ User Area #7]...<dbname>_I.d1, <dbname>_I.d2, ..... [ User Area #I]

Make sure your have on your OS backup all the above files, plus the file <dbname>.db [ Control Area ].For version 8, you will have no User Area, i.e. no file <dbname>_I.dJ.
The files<dbname>.a1, ... <dbname>.aM [ After Image Area ]<dbname>.t1,... <dbname>.tN [ Transaction Log Area ]do not need to be included within your "database backup".
Last Modified Date9/13/2015 4:08 AM

The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.

Was this article helpful?


Your feedback is appreciated.

Please tell us how we can make this article more useful.

Characters Remaining: 255