http://www.scconfigmgr.com/2013/05/08/shrink-the-sql-server-reporting-services-log-database-used-by-configmgr/
From: [email protected] [mailto:[email protected]] On Behalf Of Heaton, Joseph@Wildlife Sent: Tuesday, August 11, 2015 9:03 AM To: [email protected] Subject: [mssms] SQL database settings Taking a look at my SQL setup for SCCM. I notice that my ReportServer_log.LDF is 181GB in size. This seems a bit extreme to me. Looking at the ReportServer database properties, I see that the recovery model is FULL. Is this standard, or can I change to Simple? I know that if I change to Simple, that the .ldf file will shrink, but I don't want to put myself in a bad situation. Thanks, Joe Heaton
