Solution Properties
Solution ID:
224924850072459
Last Modified Date:
Mon Jul 06 15:20:40 UTC 2026
Taxonomy Path:
Category//Data//Backup
Author:
legacyauthor
Reduce Sage 100 Storage by Removing Unused Data Files
Description
Cause

File sizes for the Sage 100 installation have grown considerably.

This takes up hard disk space on the server and consumes time and space when running backups.

Resolution
[BCB:1:Backup warning:ECB]

 

The following are ways to reduce the amount of space taken up by files in Sage 100.

Delete rebuild utility backup files

Sage 100 creates backup files when you rebuild data files using the Rebuild Key Files utility.
  • These files use the .OLD extension.
  • They become obsolete after a successful rebuild and continued system use.
  • They don’t support restoration after ongoing processing.

File naming formats

    • [Data Table Name]+[User Code]+[Month]+[Day]+[Decimal Time]+.OLD
    • [Data File Name]+[Company Code]+.OLD

Examples

    • AP_OpenInvoiceUSR123112726338.OLD
    • PR1XXX.OLD

Delete temporary Crystal work tables

Sage 100 creates temporary Crystal work tables when you run reports or forms.
  • These files appear after selecting Print or Preview.
  • The system usually deletes them automatically.
  • Some files remain and consume disk space.

File naming format

    • [Work Table Name]+[User Code]+[Month]+[Day]+[Decimal Time]+.m4t

Examples

    • SO_InvoiceWrkUSR123112840686.m4t
    • PO_PurchaseHistoryWrkJS123109123456.m4t
You can safely delete leftover temporary files.

CAUTION:

Don’t use batch commands with *Wrk*.m4t to avoid deleting required template files (*.Wrk.m4t).

Delete training, test, or copy companies
Organizations often create additional companies for testing or training.
  • These companies duplicate live data or simulate scenarios.
  • They consume storage space like production companies.
Review all non-production companies and remove those no longer needed.

NOTE:

 Delete the company code to remove all related data. For more information: Delete a company code and remove all data for a company

Run record purging utilities

Sage 100 includes utilities that remove outdated or unnecessary records.
  • Each module offers purge options based on criteria such as date.
  • Purging reduces the data volume stored in system files.

NOTE:

For more information: In a relevant module's Utilities menu, select a task option and click the Help (question mark icon) button to access Help information. Or search the Sage Knowledgebase for information on the specific utilities you are interested in running.

 Important considerations

  • Purging permanently removes selected records.
  • Reports lose access to deleted historical data.

CAUTION:

Proceed with caution. Get approval before purging the data.  Accountants or auditors often require historical records.  Purging data may result in undesired data loss. For example, the Purge Accounts Receivable History utility removes invoice records from the invoice history up to a specific date! This may result in reports that no longer provide specific information as desired or required by accountants or auditors.

NOTE:

It’s highly recommended to get approval from qualified decision-makers before deciding to purge historical data. If in doubt about what records a specific utility removes, contact the Sage 100 Customer Support Applications team.

TIP:

For general information on how to back up and restore system and data files for Sage 100, see Backup and restore data, programs, and system files

  • There’s a limitation on Sage 100 data file size of about 2 GB in size.  One or more segmented files are generated automatically upon reaching this size limit. The segmented files are extensions of the original file, with the same fields and file structure.  See: There are segmented data files for some data files

  • EXAMPLE:

    1. IM_ItemTransactionHistory.M4T
    2. IM_ItemTransactionHistory.M4T.001
    3. IM_ItemTransactionHistory.M4T.002, etc.
       
[BCB:155:Chat 100 US:ECB]

 

Steps to duplicate
Related Solutions