Sybase backup and restore

SAP Notes: 1588316 - SYB: Configure automatic databaseand log backups

 

1.     Createfolder for backup databases and transaction logs

/sybase/DL4/sapdata_1/backups

/sybase/DL4/sapdata_1/log_archives

 

2.     Createyour dump configuration with stored procedure 'sp_config_dump'. If the name ofthe database is, for example, DL4:

 

use master

sp_config_dump @config_name ='DL4DB',

@stripe_dir = '/sybase/DL4/sapdata_1/backups',

@compression = '101' ,

@verify = 'header'

go

 

Configuration DL4LOG:

 

sp_config_dump @config_name ='DL4log',

@stripe_dir = '/sybase/DL4/sapdata_1/logarchives',

@compression = '101' ,

@verify = 'header'

go

 

3.     Changethe DB parameter below:

sp_dboption 'DL4','trunc log on chkpt','false'

sp_dboption 'DL4','enforce dump tran sequence','true'

 

4.     Databaseand transaction dumps can now be performed using the 'using config' syntax.

Example:

dump database DL4 using config = 'DL4DB'

go

 

dump transaction DL4 using config = 'DL4log'

go

 

5.     Restoredatabase:

load database DL4 from '/sybase/DL4/sapdata_1/backups/DL4.DB.20160330.153542.000'

 

Recovery log files:

load transaction DL4 from'/sybase/DL4/sapdata_1/log_archives/DL4.TRAN.20160330.155435.000'

 

6.     Createand schedule ASE jobs to backup databases and transaction logs

 

Use the DBA Planning Calendar in the DBACOCKPIT toautomatically call the 'DUMP DATABASE' and the 'DUMP TRANSACTION' commands.