Today I noticed on two of my SCCM 2012 infrastructures that the ReportServer_log.ldf file was extremely large (>100GB). This is quite concerning considering that the actual database is less than 256MB. I have not yet investigated the root cause yet, but here is a workaround / solution to reclaim the disk space and prevent it from growing large again.
- Open SQL Server Management Server and connect to the SQL Reporting Services Server (most likely your SCCM Primary server)
- Change the ReportServer database Recovery Mode to “Simple” (right-click on the ReportServer database and select properties)
- Manually backup the ReportServer database (right-click on the ReportServer, select Tasks, select backup, …)
- Truncate the log file (start a new query and run “DBCC ShrinkFile (ReportServer_log, TruncateOnly“)
- Configure the ReportServer database AutoGrowth to use a maximum file size (2048MB should be sufficient) (right-click on the ReportServer database and select properties, select Files, …)
You should now see that the log file is only a few MB.
References and additional guidance
Chad January 6, 2014
Posted In: SQL Reporting