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

  • November 21, 2013 at 12:38 pm

    #1668227

    Koen Verbeeck (2/11/2011)

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

    I too am getting:

    Msg 9002, Level 17, State 4, Line 10

    The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

    and I just had our system admin restart server, but problem is same. Using SQL Server 2008 R2.

    The log_reuse_wait value in sys.databases was 4 before and still is.

    I am going to read about Checkpoint...with the links provided.

    --Quote me