?
Solved

Sharepoint Log File is 10GB

Posted on 2010-11-18
2
Medium Priority
?
799 Views
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.
0
Comment
Question by:StarfishTech
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Assisted Solution

by:psv1973
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?
0
 
LVL 38

Accepted Solution

by:
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.  

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
Suggested Courses

764 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