1. Home
  2. Point-Of-Sale Software
  3. HQEventLog table size and maintainance

HQEventLog table size and maintainance

I am Running RMS HQ with 38 stores and growing. Each store has two POS lanes and we don't do a large volume of transactions in any given day. The size of my DB is concerning me, so I ran a query that returns the size of each table, and what I found is that 95% of the size of my HQ DB is contained in "HQEventLog" and "TimeStandLog". What I want to know is 1. Would there be any long term problem in periodically purging anything in either/both of these tables that is older than 30 days? 2. What would be the best way to do this (script to use and any suggestions for automation would be great). Just to give you an idea, the current size of the HQEventLog table reports at

2.2GB and the TimeStampLog at 903MB.

Thanks, Brandon

Reply to
dizz
Loading thread data ...

Brandon,

If running 1.3, HQ Manager | View | Event Viewer | red X | select the dates you wish to delete

Reply to
Jeff

Jeff, Thanks - I am running 1.2 - but the same options exist - any reason I can't do it in 1.2 (we have been told to hold off on the upgrade to 1.3 by our MS Partner until they are done testing with our customization since we have such a large install base)...

Also a follow up questi> Brandon,

Reply to
dizz

Dizz or Brandon,

Didn't remember if it was in that version too.

I would run a shrink after as I doubt the program would on its own.

Being safe, backup before the delete and again before the shrink!!

Reply to
Jeff

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.