Skip to Content

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 15.7.0.132 and ECC 6.0 EHP7.

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

Best regards,

Duy

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    May 19, 2015 at 06:53 AM

    Hi Duy,

    Please check your database log

    D:\sybase\SID\ASE-16_0\install\SID.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

    go

    sp_config_dump

    go

    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

    go

    Kind Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded