How to enable and disable Sybase Transaction Log

7 February 202420 December 2023 by Amar Singh

Discover essential methods to manage Sybase transaction logs efficiently. Learn how to enable and disable Sybase Transaction Log.

In my scenario SBP is DB SID.

If I want to disable transaction log: –

use master
go
sp_dboption SBP, 'trunc',true
go

use SBP
go
checkpoint
go

And I want to enable again: –

use master
go
sp_dboption SBP, 'trunc',false
go

use SBP
go
checkpoint
go

The checkpoint command is mandatory to change the mode of transaction log?