Last October (2010), I posted the following bug on Microsoft Connect (https://connect.microsoft.com/SQLServer/feedback/details/615123/ssrs-2008-r2-keepfilesfordays-config-file-item-does-not-appear-to-work). Essentially, the SQL Server Report Server (SSRS) 2008 R2 KeepFilesForDays parameter in the ReportingServicesService.exe.config file isn’t working as advertised in BOL for deleting expired log files. And, until today, when I went to manually delete them, I still had every log file since I installed in June 2010!
A few weeks ago, Microsoft officially closed my Connect item as “Fixed”. But, no word on when/where it is fixed. I still see the problem in SQL 2008 R2 SP1 and I don’t see a mention of a fix for this in any of the three (3) CU’s released for SP1 so far. It also appears that this is likely a problem in SSRS 2008 and SSRS 2005 based on a handful of inquiries I spotted in various forums when researching. Although in SSRS 2005 the parameter setting and log files are in different locations due to SSRS’s usage of IIS for that version. I also checked my Denali CTP3 installation of SSRS and sure enough – every log file since I installed (way, more than the default 14 days) still exists.
So, just a word of warning, if you assume that this parameter is working for you – it probably isn’t and you’ll need to find another way to delete your old log files for SSRS. If you have plenty of space on the drive where these are stored, then it isn’t an issue – yet. But, beware!
Filed under: SQL Server, SQLServerPedia Syndication | Tagged: Denali, KeepFilesForDays, logging, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Reporting Services, SSRS | 7 Comments »