ASE - Dump Database (Transaction Log deleted?)

[Private_Member_19084]

Hi experts,

I have a question.

Will the transaction log be deleted reseted to the time of a database dump is finished?
Hopefully it will only be deleted by dumping the transaction log itself, right?

Kind regards

[former_member89972 · Accepted solution]

Hi

For SAP/Sybase ASE a full database dump does NOT truncate transaction log.

Assuming that "truncate log on checkpoint" is NOT set.

the transaction log is truncated only when you execute  "dump tran" for that database.

HTH

Cheers

Avinash

[Private_Member_19084 · Accepted solution]

Hello Avinash,

perfect answer and good news to me

[former_member187136 · Accepted solution]

Hello Christian,

Don't worry we have set the options to the databases which are getting installed through business suites.

However I will provide you the detailed dB details and their respective option which yoibcan cross verify as well from the isql command

sp_helpdb

go

And you can very well enable or disable the options set as well using

sp_dboption "<SID>","<option_name>",true/false

go

Also if you needed the detailed dB wise default dB options that to be set let me know I will attach the details as well 😉

Regards

Kiran K Adharapuram

[Private_Member_19084 · Accepted solution]

Hello Kiran,

thx a lot. I really appreciate your support.