Sharepoint Log File is 10GB

Posted on 2010-11-18
Medium Priority
Last Modified: 2012-05-10
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.
Question by:StarfishTech

Assisted Solution

psv1973 earned 1000 total points
ID: 34165604
There might be a lot of unused empty space in your config database. Did you try to shrink it using SQL Management Studio?
LVL 38

Accepted Solution

Justin Smith earned 1000 total points
ID: 34166767
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.  


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Let us take a look at the scenario, you have a database that is corrupt and you run the ESEUTIL command only to find you are unable to repair it. How do you now get the data back?
In this article, we will discuss how you can secure Active Directory using free tools, and how you can choose a safe and secure Active Directory security auditing tool.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question