HQEventLog table size and maintainance

May 18, 2006 3 Replies

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


Brandon,

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

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,

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!!

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required