Thanks. Changed it to Simple around 30-40 minutes ago now. When you say shrink, do you mean database, or files? I'm assuming files, but didn't want to do the wrong one.
From: [email protected] [mailto:[email protected]] On Behalf Of Damien Solodow Sent: Tuesday, August 11, 2015 7:09 AM To: [email protected] Subject: [mssms] RE: SQL database settings If you have it set for FULL and aren't doing transaction log backups it will keep growing. Since it's report server, you probably don't lose anything by having it set to SIMPLE. If you change it to SIMPLE, you'll need to wait a few minutes for it to checkpoint and then you can shrink it. DAMIEN SOLODOW Senior Systems Engineer 317.447.6033 (office) 317.447.6014 (fax) HARRISON COLLEGE From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Heaton, Joseph@Wildlife Sent: Tuesday, August 11, 2015 10:03 AM To: [email protected]<mailto:[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
