Backup configuration in SAP Sybase

1 Prerequisites:

Access of backend.

User: sybSID

User: sapsa

2 Solutions:

We have 2 scenarios here:

1: Configuration for backup.

2: Configuration for log-backup.

Configuration for Backup:

Login with user sybsid

Now change the user sapsa by command

isql –Usapsa -SSID Enter password.

1>use master

2>go

1> sp_config_dump @config_name='SIDDB',

2> @stripe_dir = 'path of directory where we want to store the data backup',

3> @compression = '101’,

4> @verify = 'header'

5> go

Configuration for Log:

Login with user sybsid

Now change the user sapsa by command

Isql –Usapsa -SSID Enter password.

1>use master

2>go

1> sp_config_dump @config_name='W01SID',

2> @stripe_dir = 'path of directory where we want to store the log backup',

3> @compression = '101',

4> @verify = 'header'

5> go

#sybasebackup #sybasebackupconfiuration #sapsybaseconfiguration #sybasedatabaseconfiguration #BackupconfigurationinSAPSybase