• Categories

  • Recent Posts

  • Archives

  • Copyright Notice

    Copyright © Nancy Hidy Wilson, 2010-2013. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Nancy Hidy Wilson and nancyhidywilson.wordpress.com with appropriate and specific direction to the original content.

SSRS Log Files Retention Bug


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!

Advertisements

7 Responses

  1. Hi,

    As far as I can tell this bug still exists in all current versions of SQL Server. I initially thought this might be due to file system permission ‘deficiencies’ but the SQLServerReportServerUser$ group does have the ability to delete files in the folder I’m using for logging.

    Paul

    • Paul,
      I recently recieved an update from Microsoft that this bug is now fixed in SQL Server 2012 (although I’ve not had a chance to verify yet) and will be fixed in an upcoming CU for SQL Server 2008 R2 and they are looking for a way to provide a fix in SQL Server 2008. Obviously anyone with the issue on SQL Server 2005 is stuck with it, but probably has had a workaround in place for years now.

      Regards,
      Nancy

  2. We have the same problem with SQL 2008R2, the logfiles does not get deleted! Is there still no resolution?

  3. Excellent post, thank you so much for the useful information. I was able to free 50GB from my log directory!

  4. […] SSRS Log Files Retention Bug. […]

  5. I see that it is fixed in SQL 2008 R2 SP2, since I only have 14 days of logs there

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: