Transaction Log Full in Simple Recovery Model

• MohammedU

  SSCoach

  Points: 19644

  More actions

  March 11, 2007 at 1:27 pm

  #694280

  Reason could be big transactions... check it out if you have any large sinle transaction...

  ex: If you have table with 10 mil rows and running delete against it instead of truncate table may cuase the log full even the db is simple recovery model because it is single transactions....

   

  MohammedU
  Microsoft SQL Server MVP

• Amit Kumar

  SSChasing Mays

  Points: 614

  More actions

  March 11, 2007 at 10:23 pm

  #694294

  Mohammed is right. Also, check with the free disk space. The free disk space ratio should match with DB size. For all the big transactions, free space is required for the temp folder.

  Amit