Home Forums SQL Server 2012 SQL 2012 - General SQL2012SP1, simple recovery, transaction log full, can't add another, won't grow RE: SQL2012SP1, simple recovery, transaction log full, can't add another, won't grow

  • May 15, 2013 at 10:45 am

    #1615531

    Tommy Bollhofer (5/15/2013)

    You may also want to take a look at this thread on SSC -

    http://www.sqlservercentral.com/Forums/Topic708053-146-1.aspx

    Interesting.

    checking mine:

    select * from sys.sysprocesses where lastwaittype like '%LOG%' or lastwaittype like '%CHECKPOINT%' or cmd like '%LOG%' or cmd like '%CHECKPOINT%'

    I have a CHECKPOINT cmd that is in lastwaittype 'LOGMGR_RESERVE_APPEND', shows CPU 20841, and its login time and last batch are both two days ago (probably at my last reboot), and has stmt_start=0, blocked=0, waittime=386.