I have a SQL Server 2005 instance that hosts a database for Microsoft Sharepoint used internaly by our company staff. The log file is approaching 11GB in size and appears to permanently be 99% full. The database is in simple recovery mode. Forcing a checkpoint appears to have no effect. There are no integrity errors and no open transactions. There are no file growth or size restrictions and plenty of available disk space for both files. At 99% full, I am unable to shrink the log file or find an explanation of why it never truncates. I would be happy if anyone has a suggestion to offer. A more detailed listing of my diagnostic queries and results are below: EXEC sp_helpdb SharepointContent GO Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=Latin1_General_CI_AS_KS_WS, SQLSortOrder=0, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled File Type Size Max Size Growth Usage Data 13470912 KB Unlimited 1024000 KB data only Log 11000064 KB 2147483648 KB 102400 KB log only USE SharepointContent GO CHECKPOINT GO DBCC UPDATEUSAGE (0) GO DBCC SQLPERF (LOGSPACE) GO Name Log Size (MB) Log Space Used (%) Status SharepointContent 10742.242 99.397751 0 DBCC OPENTRAN GO Transaction information for database 'SharepointContent'. Replicated Transaction Information: Oldest distributed LSN : (0:0:0) Oldest non-distributed LSN : (21543:3418:1) DBCC CHECKDB GO CHECKDB found 0 allocation errors and 0 consistency errors in database 'SharepointContent'.