November 21, 2005 at 12:25 pm
Hello,
My Reporting Sevices generated more the 10 GB of logs, about 400 files in one day in the directory
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
which is a default directory for Reporting Services Trace Logs. This report server is running for 1.5 years as development, no one is really using it, almost no logs were generated ever before. Out of nowhere, on Saturday more then 10 GB of log files were generated with the same records:
ReportingServicesService!runningjobs!d4c!11/19/2005-13:08:58:: i INFO: Execution Log Entry Expiration timer enabled: Cycle: 46261 seconds
ReportingServicesService!dbcleanup!3544!11/19/2005-13:08:58:: i INFO: Expiring old execution log entries
ReportingServicesService!dbcleanup!3544!11/19/2005-13:08:58:: i INFO: Expiration of old execution log entries is complete. Removed 0 entries.
ReportingServicesService!dbcleanup!3544!11/19/2005-13:08:58:: i INFO: Cleaned 0 broken snapshots, 0 chunks
No one was working on Saturday, no jobs are defined on the report server.
I did look up in Reporting Services BOL and today I reset config file to use Trace Level 0 - No Logging, so it hopefully will be OK in the future.But I wonder if someone had similar experience, why all of sudden after a year and a half of almost no logging on the weekend day with no one working and no jobs 10 GB of logs with the same records were generated.
File:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\ReportingServicesService.exe.config
Entry:
<system.diagnostics>
<switches>
<add name="DefaultTraceSwitch" value="0" />
</switches>
</system.diagnostics>
Regards,Yelena Varsha
November 22, 2005 at 7:39 am
This happened to me. All of a sudden, the LogFiles directory was filled up with many files that added up to "all my free space".
The solution that I found from Microsoft's KB was to apply service pack 2 for SQL RS. After doing that, all is well.
November 22, 2005 at 9:13 am
Thanks!!!
I will do that. But I will keep trace level 0 (no logging).
Do you know by chance how to move log files to another location, for example to another drive? I did not find a tag in a config file for that
Yelena
Regards,Yelena Varsha
November 22, 2005 at 9:25 am
Sorry, but I do not know how to move the log file.
Is that trace level 0 thing working out for you/
thanks,
jg
November 22, 2005 at 4:39 pm
Jeff,
I don't know. There are no more ReportServerCervice logs that looked like:
ReportServerService__11_19_2005_12_58_08.log
but there are 2 short logs from Report Server (without Service) like
ReportServer__11_21_2005_11_29_10.log
I will better apply the service pack.
Thanks for your help!
Regards,Yelena Varsha
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply