Non Critical Database Files
The following data files are infrequently changed or are not tightly interlinked with other CAPITAL database files. It may be possible to selectively restore these files from a back-up. This may help to minimise data loss if it becomes necessary to restore damaged files.
Do
not attempt to restore files from a back-up that is prior to the last system upgrade. For example, if
you were running CAPITAL 7.0 and have upgraded to CAPITAL 7.1, do not attempt to restore files
from a back-up of CAPITAL 7.0.
Always perform a Database Maintenance operation after selectively restoring files.
Any file that has an accompanying *.CFS file may be selectively restored. However, be sure to restore all related files. For example, if the problem file is CONTACTS.DBF then be sure to restore all CONTACT.* files from the back-up.
|
APPOINT.DBF |
Appointment Schedules |
|
APPOINT.DBT |
Always restore APPOINT.DBT if restoring APPOINT.DBF |
|
BAS.DBF |
BAS categories table |
|
BROWSE.DBF |
Browser column arrangements |
|
CENTRE.DBF |
Service Manager Cost Centres |
|
CLERKS.DBF |
Clerk ID's and names. |
|
CMAUTO.DBF |
Automatic cashbook postings |
|
CMBANK.DBF |
Bank accounts |
|
CMDEPLST.DBF |
Bank deposit list history |
|
CONFIG.CAP |
Configuration file |
|
CQLIST.DBF |
Cheque run list - temporary buffer file |
|
CQLIST_T.DBF |
Cheque run list - temporary buffer file |
|
CURRENCY.DBF |
Currency/exchange rate table |
|
CUSTADR.DBF |
Customer address table |
|
EXPENSE.DBF |
Expense codes table |
|
GLBAT_J.DBF |
Standing journals. Be sure to restore the associated GLBAT_J.DBT file if one exists |
|
GLBAT_JT.DBF |
Standing journals. Be sure to restore the associated GLBAT_J.DBT file if one exists |
|
GLCALC.DBF |
General ledger financial formulas |
|
GLSETS.DBF |
General ledger sets |
|
MATCH.DBF |
Cross-reference database for stock items |
|
MATRIX.DBF |
Customer special pricing |
|
MATRIXSU.DBF |
Supplier special pricing |
|
MESSAGES.DBF |
Messages database |
|
OVLIST.DBF |
Overdue letters - temporary buffer file |
|
OVLIST_T.DBF |
Overdue letters - temporary buffer file |
|
RELIST.DBF |
Remittances - temporary buffer file |
|
RELIST_T.DBF |
Remittances - temporary buffer file |
|
REPORTS.DBF |
Report selections table |
|
SNPICK.DBF |
Special Property Tracking Pick Selections |
|
SNSPEC.DBF |
Special Property Tracking configuration specifications |
|
STLIST.DBF |
Statements - tempirary buffer file |
|
STLIST_T.DBF |
Statements - tempirary buffer file |
|
TAXTABLE.DBF |
Tax rates |
|
TRANSPEC.DBF |
Transaction specifications (redundant) |
|
TRSORT.DBF |
Transaction sorting options |
|
TYPE.DBF |
Stock groups |
14/03/2001