Skip to Content

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

Loading Stored procedure in sybase

Hi all,

I am trying to setup a backup for transaction log in sybase . I am refering to note 1588316 where script files are attached and the configuration scripts are given. I am able to take a database backup using sp_config_dump (stored Procedure) . Which is now scheduled in the DB13( DBACOCKPIT ).

But I am yet to setup transaction log backup which should happen every 30 mins as planned.

I am refering to the thread How create a backup , Which describes a way to configure a script in SAPTOOLS . But when I try to load the file sp_dumptrans.sql using the steps described , I am getting some errors.

Please help me on this as I am new to Sybase . I am also attaching a screenshot of the error which shows up.

Thanks in advance

Regards,

Suratharajan .S

Tags:
Former Member replied

Hello,

net password encryption is enabled by default for the ASE.

See SAP Note 1858378, just add -X at the end of your ISQL command and it should work.

With kind regards

Stefan

0 View this answer in context

Helpful Answer

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