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

  • Is it possible there are any uncommitted distributed transactions? What is the initial file size for the log file? Is the recovery interval value for the database set at the default of 0? Have you tried issuing a CHECKPOINT? Try with a duration of 5 or 10; i.e. CHECKPOINT 5