I had the problem that Sharepoint_Config-ID-.log.ldf grew really BIG (14GB) on a content database of 1 GB!
\nThis caused issues where the log was taking up all the available free space on the server, not OK!<\/p>\n
You can solve this problem by using \u201cShrink\u201d command in the MS SQL Server Management Studio Express<\/p>\n
First you need to connect to your Sharepoint 3.0 database called: \\\\.\\pipe\\mssql$microsoft##ssee\\sql\\query \u2013 just put this string in your \u201cServer name\u201d field:<\/p>\n
\\\\.\\pipe\\mssql$microsoft##ssee\\sql\\query<\/p>\n
Create full backup of all databases before continuing!<\/p>\n
After that we should change restore mode from \u201cFull\u201d (this the parameter that allows .log.ldf to grow that large as transaction logs are not purged) to \u201cSimple\u201d:<\/p>\n
Expand Databases, right mouse click on Sharepoint_Config\u2026 Properties, Options, Recovery model: Simple and click OK<\/p>\n
Shrink the database procedure:<\/p>\n
Expand Databases, right mouse click on Sharepoint_Config\u2026 Tasks, Shrink, Files in File type select Log and click OK
\nYour log file will become radicaly smaller. \ud83d\ude42<\/p>\n
Be sure you backup your databases before this procedure and also on a daily basis\u2026<\/p>\n
Good luck!<\/p>\n
Also check:
\nhttp:\/\/geekswithblogs.net\/RogueCoder\/archive\/2008\/06\/03\/122588.aspx
\nhttp:\/\/www.karaszi.com\/SQLServer\/info_dont_shrink.asp<\/p>\n
All credit goes to: http:\/\/luka.manojlovic.net\/2008\/06\/15\/reduce-sharepoint-services-30-logldf-files\/<\/p>\n","protected":false},"excerpt":{"rendered":"
I had the problem that Sharepoint_Config-ID-.log.ldf grew really BIG (14GB) on a content database of 1 GB! This caused issues where the log was taking up all the available free space on the server, not OK! You can solve this problem by using \u201cShrink\u201d command in the MS SQL Server Management Studio Express First you … <\/p>\n