This is a quick hitter I ran into the other day. My SQL Drive for SCCM kept filling up, after looking into it the SCCM report server log file was growing like crazy, it ate 17gb in two days. It eventually grew to over 200gb.
To resolve is easy enough, on your SQL server start SQL Management studio, connect to the instance with the report server database, right click on it and select properties, then go to options and set Recovery model to Simple. After setting it to Simple it quickly shrank itself back down to a manageable size.
Hi, I’m Billy York. I’m a Consultant at Microsoft, former Cloud and Datacenter Management MVP, specializing in monitoring and automation. Here you’ll find posts about AzureMonitor, LogAnalytics, System Center Operations Manager, Powershell, Hyper-V, Azure Automation, Azure Governance and other Microsoft related technologies.