Database Option 'trunc log on chkpt' turned off / Dump transaction is not possible on database in ASE

While tacking log backup in Sybase ASE the following errors may showing,

Database Option 'trunc log on chkpt' turned off for Database 'SID'

or

Dump transaction is not possible on database

Error Screens :-

Solution :-

This is because of the parameter sp_dboption value not set, this should be false

Follow the below to configure the parameter,

      1. Login to Isql

          1> Use Mater

          2> go

          1> sp_dboption SID,  "trunc log on chkpt", false

          2> go

  Retry to take the backup, now backup will work.

Thanks for reading, Please share your valuable feedback.  

Share this

Basis Genie