There is an error message in the SELECTserver log files that the SQLtransaction logs are full
To shrink the SQL Transaction logs, first figure out the databaserecovery mode. To find out if you database recover mode is set to full,bulk-logging, or simple right click on database, properties, click onOptions in the window, 2nd drop down is the mode. Here is bit more infoon DB recovery modes:http://msdn.microsoft.com/en-us/library/aa173531%28v=SQL.80%29.aspx)If your database recovery mode is set to FULL or bulk-logging, use theSQL statement below.The example script looks like thisUSE [master]GOALTER DATABASE [TestDb] SET RECOVERY SIMPLE WITH NO_WAITDBCC SHRINKFILE(TestDbLog, 1)ALTER DATABASE [TestDb] SET RECOVERY FULL WITH NO_WAITGOWhen you use the statement above you have to change some of the valuesto match your database for a test db. This is what it looks like with adatabase name of hdr_oma_2-15-11USE [hdr_oma_2-15-11]GOALTER DATABASE [hdr_oma_2-15-11] SET RECOVERY SIMPLE WITH NO_WAITDBCC SHRINKFILE(PWOMA_HUB_Log, 1)ALTER DATABASE [hdr_oma_2-15-11] SET RECOVERY FULL WITH NO_WAITGOIn this case, hdr_oma_2-15-11 is the name of the database as seen in sqlmanagement studioPWOMA_HUB_Log is the logical name of the transaction log. You can findthis by right clicking on the database and selecting properties, clickon 'files' and look in the 'logical name' column.If your database recovery mode is set to Simple the script is a bitsimpler,USE [master]GODBCC SHRINKFILE(TestDbLog, 1)GOSo in my caseUSE [hdr_oma_2-15-11]GODBCC SHRINKFILE(PWOMA_HUB_Log, 1)GO
http://blog.sqlauthority.com/2010/05/03/sql-server-shrinkfile-and-truncate-log-file-in-sql-server-2008/