Loading Stored procedure in sybase
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
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