How to disable Transaction log on Sybase ASE

During Execution phase of an upgrade, when you ae performing archiving activities on Development or Quality system but you don't have enough space for keeping transaction data or because of some specific reason if you want to disable the trans log on your Sybase system you can follow this option.

This is not recommended on Production systems because as the transaction log is used for performing a complete restoration of data. 

1. Log in on your server with user SYBSID 

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

> isql -Usapsa -P< password > -S< SID > -X

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

1> use master

2> go

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

2> go

Database option 'trunc. log on chkpt.' turned OFF for database ''.
Running CHECKPOINT on database '' for option 'trunc. log on chkpt.' to take
effect.
(return status = 0)

1> checkpoint

2> go

Use below commands to change the Setting "true" to "false".

1> use master

2> go

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

2> go

Database option 'trunc. log on chkpt.' turned OFF for database ''.
Running CHECKPOINT on database '' for option 'trunc. log on chkpt.' to take
effect.
(return status = 0)

1> checkpoint

2> go

Share this

Basis Genie