I have my ISA2004 logging to a SQL server. The biggest issue I have here is that when logging to SQL, there is no option for ISA to remove entries over a certain age like there is with the MSDE or FILE options.
The problem I have is that the logs grow, and when I then manually go to clean out the old entries, it takes *ages* and absolutely hammers the SQL server in the process.
Does anyone else use SQL logging, and how do you manage the log sizes?
From: Orange County, CA
This is handled through SQL server. You'll need to create a "Job" that runs daily on the server with the following code.
/*Begin code*/ DELETE FROM webproxylog WHERE logTime < DATEADD(dd, DATEDIFF(dd,0,GETDATE()), 0) - 60 /*End code*/
The "60" at the very end of the code will delete all records from the WebProxyLog that are older than 60 days (compared to the current date of your SQL server). Of course you can change the number to whatever you want.