How to modify the log mode on Sybase ASE

To modify the log mode on Sybase ASE, you have to follow further steps :

1. Log in on your server with user syb<sid>

2. Launch with a command line tool to connect to ASE database

> isql -Usapsa -P<password> -X

3. On the SQL interface, enter the statements to change log mode

1> use master

2> go

1> sp_dboption <SID>, 'trunc',false

2> go

Database option 'trunc. log on chkpt.' turned OFF for database '<SID>'.

Running CHECKPOINT on database '<SID>' for option 'trunc. log on chkpt.' to take

effect.

(return status = 0)

1> checkpoint

2> go

1>