You may notice that these databases become larger than expected on the C:\ drive of a default SBS 2008 installation. You will have to shrink them to regain the space that the log (.ldf) files are consuming.
Databases that might be affected:
Folder location of these databases that you will see grow in size:
1. Open SQL Management Studio and connect to database instance – Location: Start > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio Express
Server name will be: “\\.\pipe\mssql$microsoft##ssee\sql\query” Click Connect.
NOTE: You may receive a login error even if you are logged in as a domain admin. If that’s the case, close SQL Management Studio and reopen it by right-clicking and running as Administrator.
2. Right click on the database that we need to reclaim space from and click New query.
3. The query window will appear on the right. Enter the following text:
ALTER DATABASE “SharePoint_Config_type-actual-values-here” SET RECOVERY SIMPLE;
4. Then click the Execute! button
5. Right click the same database > Tasks > Shrink > Files, Change File type to Log, then Click OK.
6. Set the databases back to Full Recovery mode, run this on the same database:
ALTER DATABASE “Database_name” SET RECOVERY FULL;
Repeat steps 2 through 6 for each database that is consuming a large amount of space and then you should see a major difference in space being used.