Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  checkpoints

Author  Topic  pomela Starting Member 15 Posts Posted - 2006-09-11 : 07:26:11 One of my databases (SQL SERVER 2000) Transaction Log file is growing and never truncates. This started in the last few days (last time the server restarted was about 2 months ago) Some relevant information: The Database uses Simple Recovery Model. The "truncate log on checkpoint" option is enabled. "Recovery Interval" set to 0 (default). There are no open transactions according to DBCC OPENTRAN. When I execute "CHECKPOINT" manually the transaction log truncates, but after that it keeps growing. I tried to read the transaction log file and look for checkpoint occurrences using: SELECT * FROM ::fn_dblog(NULL,NULL) where operation ='LOP_BEGIN_CKPT' The only row I get is the one I ran manually, so I suspect checkpoint are not running on this database. Other databases on the same server are fine, and I see (using ::fn_dblog) that checkpoints runs automatically about every minute. Any ideas? Thanks in advance.