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.
StarfishTechAsked:
Who is Participating?
 
Justin SmithConnect With a Mentor Sr. 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
 
psv1973Connect With a Mentor Commented:
There might be a lot of unused empty space in your config database. Did you try to shrink it using SQL Management Studio?
0
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.

All Courses

From novice to tech pro — start learning today.