DUMP TRANSACTION is not possible on database
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 220.127.116.11 and ECC 6.0 EHP7.
I would be very grateful for any contribution to solve this issue.
Nicolaas Johannes Van Zyl replied
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:
And list output here.
Possible reason for your error could be this:
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