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

  1. 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!
  2. 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”:
  3. Expand Databases, right mouse click on Sharepoint_Config… Properties, Options, Recovery model: Simple and click OK
  4. 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.

/door