Sybase ASE database backup procedure.

[#1]

Hi all,

Actually i configure the solution manager 7.1 system preparation and basic settings also finished. Currently i configured MOPZ for updating the Patch sp9 to sp14. So that now i want to take backup of sybase backup, i am new to sybase database . Please tell the procedure for sybase ASE databse backup.

Regards

Rajesh

[yakcinar]

Hello Rajesh,

These blogs can help you.

Backup and restore Sybase ASE 15.7 database | SCN

Regards,

Yuksel AKCINAR

[Former Member]

Hi Yuksel,

  I have login with my solman and executed tcode db13 but its shows correctly, then how do take backup.

[yakcinar]

Hello Rajesh,

Goto Database SMR first.

There you can see "Backup and Recovery" and "Jobs" tabs.

In Backup and Recovery you can see database dump history.

In Jobs you can use "Add" button to schedule an action.

In action selection there is SQL Script. For SQL script you can write "dump database SMR using config = 'SMRDB'" to schedule your DB backup and write dump transaction SMR using config = 'SMRLOG' for log backup.

(SMRDB and SMRLOG configurations must be prepared like the ones in note 1588316 - SYB: Configure automatic database and log backups)

If you donot want to use configurations you can write below SQL scripts directly for DB and transaction backups.

dump database SMR to 'D:\backup\SMRbck.dmp' with verify = full, compression = 100

go

dump transaction SMR to 'D:\backup\SMRTrns.trn' with compression = 101

go

You can define schedule date, recurrence in Add action wizard.

Regards,

Yuksel AKCINAR