No disk space on SQL Server 2005 (pt 2)

Continuing on from my previous post here we once again ran out of disk space (this time whilst trying to apply Win2003 SP2 to one of the servers). I used the freeware version of TreeSize to look at where the space was going and noticed that nearly 1Gb was in use in:

C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/LogFiles/

Upon further investigation I noted that Reporting Services (SSRS) was keeping execution logs for 60 days, this included the exceptions when someone attempted a report which they had no access to. To check go in to SQL Server Management Studio->Connect->Reporting Services…->Connect. Then right-click the SSRS node in the tree and click properties. See the screenshot below for how it looked once I’d set it to 5days which for us is enough time to identify a problem one it is reported:
SSRS Log Retention Time

Advertisements

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