Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DUMP TRANSACTION is not possible on database

Hi All,

I'm trying to take a transaction log dump using DBACockpit but the job I scheduled finished with error. In the Program Log, I found the following lines:

"starting job execution at 2015-05-19 08:30:24

(1 row affected)

Error: DUMP TRANSACTION is not possible on database."

Would you please suggest some possible causes for this error and the solution for them? I'm new to ASE so I don't know how to troubleshoot the error, I was able to take the backup of database successfully with DBACockpit. Our system has ASE version is and ECC 6.0 EHP7.

I would be very grateful for any contribution to solve this issue.

Best regards,



Hi Duy,

Please check your database log


Also the timestamp of your error when you see this 2015-05-19 08:30:24 do you see any helpful additional information in st22/sm21?

In isql run the command:

use master




And list output here.

Possible reason for your error could be this:

SyBooks Online (Archive)

What do you get if you backup manually to your backup location example, just confirm your backup naming convention and location first and modify the below command appropriately.

dump database SID to "D:\Backup\backup.dmp" with compression = 2


Kind Regards,


0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question