Delete entire events table in epo

[CraigR1]

One our our onsite epo's has a very large database of events. I do not need any of these events and wish to simply clear the whole table and start again. I was originally using the recommended SQL queries for deleting events as found here: https://kc.mcafee.com/corporate/index?page=content&id=KB92098 But its incredibly slow and causes very large Log files which I cannot accomodate. I wondered if its possible to simply truncate the entire table? I'm not a SQL guru and not sure if there is any issues with doing just this, particular in regards to ePO and whats its expecting? i'm after the quickest and least space consuming method for clearing off every event from this epo.

[aguevara]

You can not truncate the table as it has foreign keys and dependencies and building those back again is tedious and not supported by us.

Probably is best to work with this article:

https://kc.mcafee.com/corporate/index?page=content&id=KB68961

It will guide you to find the top 10 events and purge them from the DB along with shrinking the DB.

Also i can advise you to modify the script and do it by batches, so the part that mentions this: 

delete top(10000)  

Try reducing the amount of events so that it give you a chance to work on regaining the space

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?