[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 803
  • Last Modified:

Sharepoint Log File is 10GB

Hello, I have a client running SBS 2008. As far as I know, this client does not use Sharepoint. However, I just happened to notice that the Sharepoint_Config LDF is over 10GB. Why did it grow so big - more importantly, how do we shrink it? The actual file name is something like Sharepoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6.ldf.
0
StarfishTech
Asked:
StarfishTech
2 Solutions
 
psv1973Commented:
There might be a lot of unused empty space in your config database. Did you try to shrink it using SQL Management Studio?
0
 
Justin SmithSr. System EngineerCommented:
You need to backup the TLog first.  THis can be done with a maintenance plan or SQL command.  

Then you'll have to manually shrink it.

Then I would change the recovery model on the database (through SQL Manager) to SIMPLE.  

http://support.microsoft.com/kb/873235
http://support.microsoft.com/kb/272318/
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now