Reduce Sharepoint services 3.0 log.ldf files…
I had the problem that Sharepoint_Config-ID-.log.ldf grow realy BIG (14GB) on a content database of 1 GB!
You can solve this problem by using “Shrink” command in the MS SQL Server Management Studio Express
First you need to connect to your Sharepoint 3.0 database called: \\.\pipe\mssql$microsoft##ssee\sql\query - just put this string in your “Server name” field:
\\.\pipe\mssql$microsoft##ssee\sql\query
Create full backup of all databases before continuing!
After that we should change restore mode from “Full” (this the parameter that allows .log.ldf to grow that large as transaction logs are not purged) to “Simple”:
Expand Databases, right mouse click on Sharepoint_Config… Properties, Options, Recovery model: Simple and click OK
Shrink the database procedure:
Expand Databases, right mouse click on Sharepoint_Config… Tasks, Shrink, Files in File type select Log and click OK
Your log file will become radicaly smaller. 
Be sure you backup your databases before this procedure and also on daily bases…
Good luck!
Also check:
http://geekswithblogs.net/RogueCoder/archive/2008/06/03/122588.aspx
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tags: big log.ldf, large log.ldf, log.ldf large, sharepoint services 3.0 large log files
June 26th, 2008 at 19:21
Great, this was the information I was looking for. I knew how to shrink the database but has problems accessing the server. Thanx to your servername string I was able to connect. Thanx!
October 2nd, 2008 at 14:13
Hey thanks so much for this, you are the man!
Really helped me out of a hole cheers again!
October 6th, 2008 at 15:55
thanks for the server string