Transaction Log in Simple Recovery

• Karim Hemani

  SSCrazy

  Points: 2063

  More actions

  December 19, 2005 at 9:15 am

  #115787

  Hi,

  I would highly appreciate if someone clarified whether the transaction log in simple recovery mode is automatically truncated at regular intervals or only after data backups.

  Thanks,

  Karim

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736578

  More actions

  December 19, 2005 at 10:00 am

  #610364

  at every checkpoint

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  December 19, 2005 at 11:26 am

  #610386

  It has to be after checkpoints. In SIMPLE recovery mode you can not do Transaction Log backups.

  -SQLBill