Home Forums SQL Server 2008 SQL Server 2008 - General The transaction log for database 'tempdb' is full. Msg 9002, Level 17, State 4, Line 2 RE: The transaction log for database 'tempdb' is full. Msg 9002, Level 17, State 4, Line 2

  • As Satnam already mentioned, restarting the SQL Server will clear up the log space used by tempdb.

    If this however is not an option, you can try the following:

    * Issue a CHECKPOINT command to free up log space in the log file.

    * Check the available log space with DBCC SQLPERF('logspace'). If only a small percentage of your log file is actually been used, you can try a DBCC SHRINKFILE command. This can however possibly introduce corruption in tempdb.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP