We have a massive amount of data in our Event Log file (SL- version 7.0). Is there any way to delete the data & if so, what effect will it have on our system/data?
Thank you,
-Stacy Leslie
Lost Accountant.... :)
We have a massive amount of data in our Event Log file (SL- version 7.0). Is there any way to delete the data & if so, what effect will it have on our system/data?
Thank you,
-Stacy Leslie
Lost Accountant.... :)
There are a lot of different ways to delete the files. We use an SSIS package for SQL that is scheduled by SQL Agent that deletes the files and the records from pstatus. The statement for the pstatus delete is
delete from pstatus where execdate < (getdate()-14)
Dwight,
Thank you for the quick response. Yes I believe that it is in the DSL root directory. Is there an easy way to delete the log files?
I assume you are talking about the eventlog folder in the DSL root directory. We delete enything over 2 weeks old. We also delete the records from the PSTATUS table for the associated eventlogs. This way it keeps the users list of eventlogs shorter and we do not get the message that it can not find the file.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,652 Super User 2024 Season 2
Martin Dráb 228,930 Most Valuable Professional
nmaenpaa 101,150