x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 239 subscribers
  • Views 2382 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
8k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
15
topics
20
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
188
topics
442
replies
djp

Any way to empty Sage 300 CRE log file?

SUGGESTED
Posted By

In log viewer it is possible to Archive & Delete but it is extremely slow, only being able to handle 200,000 records at a time and the archive only writes 10,000 per file.   I don't want to archive, I just want to delete.  I have tried ODBC connect and using access to delete but get errors, probably due to the number of records in the log file.  Tried PCC but it does not allow access to MASTER.QLM.  It is possible to simply delete the log file and start anew?   or a utility to delete records?

  • 0
    SUGGESTED

    Sage Knowledgebase article 19543 was just updated to include steps to move the QLM file to an archive folder using File Tools.

  • 0

    Hi DJP -

    For customers, I usually incorporate this in a backup script that I write for my customers.  If you are good at Powershell, then I suggest scripting a nightly compressed backup of the Data Folders, and a monthly backup to include the key folders in the 9.5 system directory.  Then I delete the QLM files in the live data after processing the monthly backup.  They are organized with a backup of the datasets as they were at that period of time, and If you need to evaluate the logs...you only have to look at 1 or 2 of 12 backups for the entire year.

    Just a different way to slay the same beast.

    Cheers,
    John McLagan
    Johnny on the Spot

*Community Hub is the new name for Sage City