Progress
Database Administration
Guide and Reference
Identifying Files For Back Up
To correctly back up a Progress database, you must archive all of the files associated with the database. Files you must back up are:
- Database files (.db, .bn, dn)
These files contain data and recent transaction information. You must back up these files as a unit; you need all these files to recover a consistent database.
- After-image files (.an)
After-image (AI) files contain information required to reconstruct a database if a database disk is lost or damaged. You roll forward these files to reprocess all transactions that occurred since the last backup. Archive each AI file when it is full or when the database is not in use. You must use an operating system backup utility.
- Event log files (.lg)
Event log (LG) files contain dates and times of important database events. They also contain messages and other historical information to help you diagnose complex problems by understanding the circumstances surrounding a failure. Back up these files regularly as part of the normal system backup procedures. You must use an operating system backup utility.
- Transaction log files (.tl)
If you use two-phase commit, the transaction log files contain information used to resolve in-doubt two-phase commit transactions. Back up these files regularly as part of the database backup procedures. You must use an operating system backup utility.
- Application files and program library files (.pl)
Back up these files regularly as part of database backup procedures. You must use an operating system backup utility.
If you store database triggers in a program library, you should maintain the library to make sure it matches the database schema. When you back up the database, PROBKUP backs up the database schema and any schema references to 4GL triggers, but it does not back up 4GL trigger code that is referenced in the schema.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |