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

  • February 12, 2011 at 2:16 am

    #1286005

    Koen Verbeeck (2/11/2011)

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

    .

    Hi Koen verbeeck,

    What is CHECKPOINT , how to issue the CHECKPONT , how it will free up the space in the tempDB ?

    Can you please explain little biit more

    Thanks & Regards

    Deepak.A