• Twitter
  • FaceBook

Welcome to ISAserver.org

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

Managing Log size to SQL server

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA Server 2004 General ] >> General >> Managing Log size to SQL server Page: [1]
Message << Older Topic   Newer Topic >>
Managing Log size to SQL server - 4.Nov.2006 7:21:23 PM   


Posts: 16
Joined: 19.Jul.2004
From: Australia
Status: offline

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?

Post #: 1
RE: Managing Log size to SQL server - 18.Oct.2007 4:11:20 PM   


Posts: 77
Joined: 7.Jun.2001
From: Orange County, CA
Status: offline
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. 

(in reply to thewspot)
Post #: 2

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA Server 2004 General ] >> General >> Managing Log size to SQL server Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts