SharePoint config Database Log File too big

SharePoint config database logs are one thing to keep an eye on since
They do have a tendency to grow. If you don't perform a full farm
Backup usually the log doesn' t get emptied and it just keeps bloating.

If you're running Ning SQL Server express with default installation, you can find the files inC: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ data

As we see in the example above, even though the database is only 6 Megs, the log file grew to 11 gigs. Let's reduce that:

1. If you don't have it yet, download and install SQL Server Management studio express from here.

2. Run the management studio and connect to your SQL Server.

3. Expand "databases" and select your Config database "Using point_config ".

4. Right click it, selectTasks-> shrink-> files

5. In the new window selectRelease unused spaceAnd clickOK.

If that doesn't decrease the database size much, do the following:

1. First to be on the safe side, let's back it up (this step is optional)

SelectNew Query

Type the following:

Backup log [Export point_config] to disk = 'd: \ configlogbackup. Bak'
Go

Where your point_config is
Name of your Config database file and D: \ configlogbackup. Bak is
Location and file name of where you'll make the backup.

And clickExecute

This may take a while if your log file is big.

2. Next clear the query (or click New query again) and enter the following commands

Backup log [cmdpoint_config] With truncate_only
Use [Export point_config]
Go

ANC clickExecuteAgain

3. Clear the query or open another query tab and enter the next command:

DBCC shrinkfile (n'sharepoint _ config_log ', 50)
Go

The 50 in the command above sets the size in MB to truncate the log
To. If your Config dB is of different name, replace
Sharepoint_config part above with your Config dB name.

And clickExecuteYet again.

The result you get shoshould be something like below:

And ofcourse the file size:

Ahhh. Finally some space.

Http://www.sharepointboris.net/2008/10/sharepoint-config-database-log-file-too-big-reduce-it/