It depends on your recovery needs, but I always change that to Simple. . .
Jeff
From: [email protected]
To: [email protected]
Subject: [mssms] SQL database settings
Date: Tue, 11 Aug 2015 14:02:51 +0000
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
