آقای ثباتی من نگفتم لاگ فایل رشد می کنه !
میگم هی لاگ میسازه روزی 5000 تا فایل تو این مسیر ساخته میشه
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles
یه بچ فایل ساختم گذاشتم تو startup ویندوز گه این فایلها رو که هر بار 4 الی 5 هزار هست پاک کنه این مشکل برای بعضی های دیگه هم تو 2005 پیش اومده .فایل Transaction log یه فایله اونم برای هر دیتابیس می دونم چیه و چطور باید کنترلش کرد و... ولی این لاگ فایل ها مربوط به ریپورتینگ سرویسه 2005 هستش و هر ثانیه یکی میسازه ( فایل تکست) و محتواش مثلا اینه :
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Iran Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServerService__11_08_2007_ 18_31_51.log</Path>
<SystemName>HAMED-16AFAB4CE</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!11/8/2007-18:31:52:: w WARN: WebServiceAccount is not specified in the config file. Using default: HAMED-16AFAB4CE\ASPNET
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities .InternalCatalogException,Microsoft.ReportingServi ces.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threadi ng.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!11/8/2007-18:31:52:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!4!11/8/2007-18:31:53:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!4!11/8/2007-18:31:53:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!runningjobs!4!11/8/2007-18:31:53:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!4!11/8/2007-18:31:53:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!11/8/2007-18:31:53:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!11/8/2007-18:31:53:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 26886 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!4!11/8/2007-18:31:53:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!11/8/2007-18:31:53:: i INFO: SQM timer timer enabled: Next Event: 30486 seconds. Cycle: 86400 seconds
ReportingServicesService!library!8!11/8/2007-18:32:07:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
ReportingServicesService!library!8!11/8/2007-18:32:11:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
ReportingServicesService!library!8!11/8/2007-18:32:14:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.Ensure CorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionMana ger.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionMana ger.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceControl ler.ServiceStartThread()
ReportingServicesService!library!8!11/8/2007-18:32:14:: Attempting to start service again...
ReportingServicesService!library!8!11/8/2007-19:26:44:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities. ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., SELECT SERVERPROPERTY failed to execute.;
Info: Microsoft.ReportingServices.Diagnostics.Utilities. ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - Shared Memory Provider: )
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.WriteSn i()
at System.Data.SqlClient.TdsParserStateObject.WritePa cket(Byte flushMode)
at System.Data.SqlClient.TdsParserStateObject.Execute Flush()
at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch (String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Microsoft.ReportingServices.Diagnostics.SkuUtil.Ge tSqlSku(SqlConnection sqlConn)
at Microsoft.ReportingServices.Diagnostics.Sku.Ensure CorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
--- End of inner exception stack trace ---
ReportingServicesService!library!8!11/8/2007-19:26:44:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities. ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - Shared Memory Provider: )
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.WriteSn i()
at System.Data.SqlClient.TdsParserStateObject.WritePa cket(Byte flushMode)
at System.Data.SqlClient.TdsParserStateObject.Execute Flush()
at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch (String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Microsoft.ReportingServices.Diagnostics.SkuUtil.Ge tSqlSku(SqlConnection sqlConn)
at Microsoft.ReportingServices.Diagnostics.Sku.Ensure CorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.Sku.Ensure CorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionMana ger.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionMana ger.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceControl ler.ServiceStartThread()
ReportingServicesService!library!8!11/8/2007-19:26:44:: Attempting to start service again...