Wednesday, July 24, 2013

ReportServer_log Size Unexpected Growth

The ReportServer_log can grow unexpectedly and eats up all your hard disk space if you didn’t configure it correctly OR using the default settings. The ReportServer_log in my environment has already grown to 64GB.

image

To reduce and limits the log size, you need to configure the settings via Microsoft SQL Server Management Studio.

1. Expand Database and select ReportServer. Right click on the ReportServer and select Tasks>Shrink>Files
image 

2. Select Log from the dropdown menu, and click OK
image

3.The size of the log file is immediately reduced
image

4. Now, go back to the Microsoft SQL Server Management Studio. Right-click on the ReportServer and select Properties
image

5. On the ReportServer_log Logical Name, click on the […]
image

6. Change the Maximum File Size to the value you want. In my case, I changed it to 1024MB, 1GB
image

That’s all. Now you have reduced and configured the maximum file size of the ReportServer_log.