SharePoint SQL LDF Log Files too large...

Here is another great post that explains some of the issues around trying to optimize SharePoint and SQL: http://mindsharpblogs.com/bill/archive/2005/01/14/181.aspx [1]   Having configured your server the wrong way could have a performance impact. Looking at the recent size of my site_log.LDF file, I noticed it was time to truncate the log.   DBCC SHRINKFILE seems to be the way to go according to: http://support.microsoft.com/kb/907511 [2]   Having discussed this issue with some MVPs, it seems that you should definitely plan your installation architecture prior to getting started.   You should strongly consider for example some of the limitations of SQL Server Express Edition (SSEE) and the default installation with WSS v3.0 while on standalone. For example, your SQL databases will be stored on your c:\ drive under C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data. You will not have any tools or interface to deal with SSEE. You will need to download and install the SQL Native Client and become familiar with SQLCMD.   So, the punchline of the story: plan your work and then work your plan !!!