Home All Groups Group Topic Archive Search About

QUERY: IIS5 log files growing bigger...

Author
26 Feb 2007 10:59 AM
Andrew Wan
I have a problem. My system C:\ was initially setup with 4GB. The
C:\Winnt\System32\Logfiles\ folder is over 500MB. I found out that everyday
IIS generates a 5MB log file.

What is the best way to cut down on log file size? How can I set up SQL
Server Reporting? How can I ensure the log files are parsed before being
deleted? Does SQL Server Reporting intelligently know what log files are
parsed and ignores already parsed files?

Author
27 Feb 2007 12:04 AM
Ken Schaefer
Would it be easier to simply change the location that IIS writes the log
files to? (i.e. to another partition or disk that has more space)? That
would alleviate the immediate issue, then we can look at the SQL Server
reporting issue.

Cheers
Ken

Show quote
"Andrew Wan" <andrew_wan1***@hotmail.com> wrote in message
news:%2373ynVZWHHA.600@TK2MSFTNGP05.phx.gbl...
>I have a problem. My system C:\ was initially setup with 4GB. The
>C:\Winnt\System32\Logfiles\ folder is over 500MB. I found out that everyday
>IIS generates a 5MB log file.
>
> What is the best way to cut down on log file size? How can I set up SQL
> Server Reporting? How can I ensure the log files are parsed before being
> deleted? Does SQL Server Reporting intelligently know what log files are
> parsed and ignores already parsed files?
Author
27 Feb 2007 1:23 PM
Andrew Wan
Well, I couldn't get ODBC logging to work. I don't even think it ever worked
since google didn't give me any results on anyone getting it working.

So yes I changed the Logfiles folder to another partition.


Show quote
"Ken Schaefer" <kenREM***@THISadOpenStatic.com> wrote in message
news:%23nTnbLgWHHA.2284@TK2MSFTNGP03.phx.gbl...
> Would it be easier to simply change the location that IIS writes the log
> files to? (i.e. to another partition or disk that has more space)? That
> would alleviate the immediate issue, then we can look at the SQL Server
> reporting issue.
>
> Cheers
> Ken
>
> "Andrew Wan" <andrew_wan1***@hotmail.com> wrote in message
> news:%2373ynVZWHHA.600@TK2MSFTNGP05.phx.gbl...
>>I have a problem. My system C:\ was initially setup with 4GB. The
>>C:\Winnt\System32\Logfiles\ folder is over 500MB. I found out that
>>everyday IIS generates a 5MB log file.
>>
>> What is the best way to cut down on log file size? How can I set up SQL
>> Server Reporting? How can I ensure the log files are parsed before being
>> deleted? Does SQL Server Reporting intelligently know what log files are
>> parsed and ignores already parsed files?
>
Author
27 Feb 2007 1:28 AM
Greg D. Moore (Strider)
"Andrew Wan" <andrew_wan1***@hotmail.com> wrote in message
news:%2373ynVZWHHA.600@TK2MSFTNGP05.phx.gbl...
>I have a problem. My system C:\ was initially setup with 4GB. The
>C:\Winnt\System32\Logfiles\ folder is over 500MB. I found out that everyday
>IIS generates a 5MB log file.

Setup a job to zip these up nightly.

>
> What is the best way to cut down on log file size? How can I set up SQL
> Server Reporting? How can I ensure the log files are parsed before being
> deleted? Does SQL Server Reporting intelligently know what log files are
> parsed and ignores already parsed files?

That's a fairly advanced question, more than can be answered in this
discussion.

(and to be honest not entirely sure of the answer.)


Show quote
>
>
>


--
Greg Moore
SQL Server DBA Consulting
sql  (at)  greenms.com          http://www.greenms.com
Author
27 Feb 2007 1:23 PM
Andrew Wan
I found a cool tool called waRmZip (web admin Remove Zip tool). Am wondering
how I can create a job with that? Do you mean a scheduled task?


Show quote
"Greg D. Moore (Strider)" <mooregr_deletet***@greenms.com> wrote in message
news:%23y$Ri6gWHHA.3568@TK2MSFTNGP06.phx.gbl...
> "Andrew Wan" <andrew_wan1***@hotmail.com> wrote in message
> news:%2373ynVZWHHA.600@TK2MSFTNGP05.phx.gbl...
>>I have a problem. My system C:\ was initially setup with 4GB. The
>>C:\Winnt\System32\Logfiles\ folder is over 500MB. I found out that
>>everyday IIS generates a 5MB log file.
>
> Setup a job to zip these up nightly.
>
>>
>> What is the best way to cut down on log file size? How can I set up SQL
>> Server Reporting? How can I ensure the log files are parsed before being
>> deleted? Does SQL Server Reporting intelligently know what log files are
>> parsed and ignores already parsed files?
>
> That's a fairly advanced question, more than can be answered in this
> discussion.
>
> (and to be honest not entirely sure of the answer.)
>
>
>>
>>
>>
>
>
> --
> Greg Moore
> SQL Server DBA Consulting
> sql  (at)  greenms.com          http://www.greenms.com
>
>
Author
27 Feb 2007 9:24 PM
Greg D. Moore (Strider)
"Andrew Wan" <andrew_wan1***@hotmail.com> wrote in message
news:%23Uju9KnWHHA.4964@TK2MSFTNGP06.phx.gbl...
>I found a cool tool called waRmZip (web admin Remove Zip tool). Am
>wondering how I can create a job with that? Do you mean a scheduled task?
>
yes


>


--
Greg Moore
SQL Server DBA Consulting
sql  (at)  greenms.com          http://www.greenms.com

AddThis Social Bookmark Button