Unanswered: trunc. log on checkpoint not truncating
I have a server running ASE 15.5 with a database with db option "truncate log on checkpoint" turned on. However the transaction log is not truncating automatically.
- nothing in master..syslogshold
- no replication involved
- data and log are on separate devices.
- manual "dump tran with truncate_only" works fine
I tried dbcc tablealloc(syslogs,full,fix) in single user, but the problem is still there.
Does anyone have a clue what might be causing this?
thank you for responding. It is my understanding that any transactional problem would result in an entry in the master..syslogshold table. Because this table is empty, I would say there are no open transactions.
We use the default transaction mode, so unchained.