Friday, 28 December 2018

How to backup SAP Sybase Database

If you want to do a backup of Sybase Database for SAP, we can do in different ways.
1. From DBACOCKPIT you can schedule in the database calendar.
2. Run the backup command from OS Level.
3. Using the third party tools.


To take the backups in sybase we need to create dump configuration. this is required to perform the backup options 1 & 2.
Below are the steps to perform using Commands at OS Level (linux).
1. Login to OS level and switch to database user.
    su - syb<sid>
2. Connect to Sybase DB level
    isql64 -Usapsa -P<password> -S<SID> -X
3. connect to master database
    use master
    go
4. Now configure dump
    sp_config_dump @config_name='<sidDB>',
    @stripe_dir = '<backup path>' ,
    @compression = '101' ,
    @verify = 'header'
    go
5. Now trigger the backup providing the file name
    dump database <SID> using config = 'dump config file name(which      we created in the above step)'

    

1 comment: