Truncate your database log file

CREATE PROC [dbo].[PROC_TruncateLog]

AS BEGIN

      DECLARE @DBName sysname,

                  @logName sysname

      --

      SET @DBName = DB_NAME()

      --

      BACKUP LOG @DBName WITH NO_LOG

      --

      DECLARE logCursor CURSOR FOR

      SELECT name

      FROM sysfiles

      WHERE groupid = 0

      --

      OPEN logCursor

      FETCH NEXT FROM logCursor

      INTO @logName

      WHILE @@FETCH_STATUS = 0 BEGIN

            SELECT @logName = RTRIM(@logName)

            DBCC SHRINKFILE (@logName)

            FETCH NEXT FROM logCursor

            INTO @logName

      END

      CLOSE logCursor

      DEALLOCATE logCursor

END