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. 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)'
Thanks
ReplyDelete