Solved

Sharepoint Log File is 10GB

Posted on 2010-11-18
2
783 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
2 Comments
 
LVL 6

Assisted Solution

by:psv1973
psv1973 earned 250 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 250 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
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…

821 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