Hi all, My application is running in the SharePoint Servevr 2007 environment, however I was encounter an error as below: "A runtime exception was detected. Details follow. Message: The transaction log for database 'XX_DB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases Techinal Details: System.Data.SqlClient.SqlException: The transaction log for database 'XX_DB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SharePoint.Portal.Analytics.Processing.UsageDataProcessor.processSrpUsageData(SharedResourceProvider srp) " The SQL log was filled up large amount of space within 2 days. I've tried to move some of the unused/testing database to another drive to free up some space, but unable to do that because the LDF files was used by another program. How can the log being fill up so quickly? Please help to fix it, thank you.

Hi, Change the database to the simple recovery model to truncate the logs and prevent them from filling up again given adequate backup alternatives.Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/

Hi, That's quite an issue. You can use this resource with screenshots of how to do it step-by-step to solve that problem. http://olorunosebijames3.blogspot.com/2011/01/dealing-with-large-transaction-log-file.html Regards! You've only got one life; help as many people as you can, and enjoy it while it lasts.

Thank you for your help, I have fixed this issue by shrinking the log file. here are some references: http://technet.microsoft.com/en-us/library/ms189493.aspx http://www.sharepointboris.net/2008/10/sharepoint-config-database-log-file-too-big-reduce-it/