Solved

Sharepoint Log File is 10GB

Posted on 2010-11-18
2
775 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

786 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