Browsed by
Category: SQL Server

Shrink the SQL Server Reporting Services log database used by ConfigMgr 2012

Shrink the SQL Server Reporting Services log database used by ConfigMgr 2012

So today I came across an issue with my SCCM database server running low on disk space. On investigation I found the ReportServer_log.ldf file had grown to over 320GB in size! It would appear this is a known issue and some simple configuration changes to your database setup can resolve this. Change the recovery model1. Log onto SQL Management Studio and connect to the SCCM instance2. Expand Databases and right click on ReportServer (your name may vary depending on your…

Read More Read More