Delete Event Log

(0) Share

Report

Posted on by Stacy Roach Leslie

305

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.... :)

*This post is locked for comments

All responses (3)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Delete Event Log

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)
Stacy Roach Leslie 305 on at

Like (0)

Report

Re: Delete Event Log

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?
Community Member Microsoft Employee on at

Like (0)

Report

Re: Delete Event Log

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.