Hi All,

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
- well over 50 rows in syslogs

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?
Thanks,
Elroy

On Monday, July 16, 2012 8:03:06 AM UTC-6, (unknown) wrote:
Is there a checkpoint process running? It is rare, but it can happen that the checkpoint process hits a fatal error and is unable to restart. (Also the checkpoint process doesn't run if you boot the server in single-user mode).

-bret