Db option "truncate log on checkpoint" not working? - 07-16-2012 , 09:03 AM
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?
Re: Db option "truncate log on checkpoint" not working? - 09-04-2012 , 04:54 PM
On Monday, July 16, 2012 8:03:06 AM UTC-6, (unknown) wrote: