Checkpoint mystery

• David O

  Hall of Fame

  Points: 3228

  More actions

  July 9, 2008 at 8:04 am

  #71631

  I have a development database with a recovery mode of simple. The t-log isn't clearing after ETL or index maintenance. Executing CHECKPOINT or BACKUP TRAN... clears the log. I've verified I don't have any open trans, it passes dbcc checkdb and I'm at v8.00.2162. Increasing the size of the t-log didn't make a difference.

  Any other ideas?

  David

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736494

  More actions

  July 9, 2008 at 9:44 am

  #840300

  I'd double check that simple mode is enabled (look in sysdatabases for status) and then I'd also look for open trans (DBCC opentran).

  That's a strange one. Is it only the ETL process? If you run other transactions, or make something up, does it checkpoint?