How to truncate the Windows log | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to truncate the Windows log

Folks, for sql 2005, SQL Server log parser can be used to load and view the windows event log records. When I tried to use this feature, found the SQL Server log parser loaded lots of information, was very slow. Is there some way we can use to truncate the windows log OR tell SQL Server only load windows log for recent several days? Thank you. ——————
Bug explorer/finder/seeker/locator
——————
KBAhttp://support.microsoft.com/kb/308427 &http://www.microsoft.com/technet/scriptcenter/scripts/logs/eventlog/default.mspx link fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
You can use the where clause when loading the log files… Read this artilce..
http://articles.techrepublic.com.com/5100-6329_11-5034923.html To speed up the process do not add the indexes to the loading table once load is completed then you can create the indexes…and make sure you db has enough free space to insert the data otherwise db will grow while load is running which will impact perfomance… Mohammed U.
]]>