Skip to main content

Backup and Restore

You can perform your SAP ASE backups by using one of the following options. Select the one that better meet your needs.

Topics

Perform a full backup​


_10
dump database <DB_SID> using config = <config_name>
_10
go

Perform a cumulative backup​


_10
dump database <DB_SID> cumulative
_10
using config = <config_file>
_10
with verify=header
_10
go

Perform a transaction log backup​


_10
dump tran <DB_SID> using config = <config_name>
_10
go

Restore your database​

Full restore​


_10
LOAD DATABASE <DB_SID> WITH LISTONLY=LOAD_SQL
_10
go

  • Get LOAD sequence (Point In Time)


    _10
    LOAD DATABASE D04
    _10
    WITH LISTONLY=LOAD_SQL,
    _10
    UNTIL_TIME="may 25, 2020 18:33:43:866pm"
    _10
    go

  • Header verification


    _10
    LOAD DATABASE D04 FROM 'emory::compression=9::D04.DB.20200522.205006.000'
    _10
    STRIPE ON 'emory::compression=9::D04.DB.20200522.205006.001'
    _10
    STRIPE ON 'emory::compression=9::D04.DB.20200522.205006.002'
    _10
    STRIPE ON 'emory::compression=9::D04.DB.20200522.205006.003'
    _10
    WITH HEADERONLY
    _10
    go

Dump History​

View Dump records from command line


_10
sp_dump_history [ @operation = {'list' | 'purge' | 'listfiles' | 'help'}]|
_10
'listpurgefiles' | 'purgefiles' | 'upgrade' | 'downgrade'}][, @until_time =
_10
'date'] [, @name = '<database or file name>'][, @dump_type = {'DATABASE' |
_10
'TRAN[SACTION]' | 'CONFIG[URATION]' | 'CUM[ULATIVE]' | 'ALTERDB'}][, @status =
_10
{'success' | 'fail' | 'deleted'}][, @file = '<filename>'][, @version = '1.0']
_10
(return status = 0)

Backup and restore your database - SAP DBACockpit​

You can schedule your backup from the SAP DBACockpit by following these steps:

  1. In SAP GUI, run transaction DBACOCKPIT.

  2. Click on Schedule an Action under Favorites to open the scheduling wizard

  3. Continue to start the configuration

DBACockpit

  1. Select Database Dump from the action drop down list.

DBACockpit

  1. Select the Database and the Dump Configuration.
Backint interface

For backint interfaces a dump configuration is mandatory. If you don't have any, please follow the steps in create dump configuration to create one.

DBACockpit

  1. Execute. Review the summary and execute the process.

alt text

  1. Finish. The job has been launched. You can check for the results in the SAP DBACockpit Logs.

alt text

Backup and restore your database - using SAP Control Center​

Access the Administration Console in SAP Control Center, and follow these steps to perform your backup/restore operations:

  1. Jump to Schema Objects-Databases-User Databases, select your database and select Back Up alt text

  2. Select Backup using configuration and the Dump Configuration for your database. (For backint interfaces a dump configuration is mandatory. If you don't have any, please follow the steps in create dump configuration to create one.)
    alt text

  3. Type of Backup. Select the type of backup that you want to perform. alt text

  4. Options. Leave the use modified options option unckecked to use the configuration profile options. alt text

  5. Summary. Review the summary and finish the process. alt text

  6. Activity Log. You will see the backup output if you have selected not to schedule the job. alt text

Where are your backup stored?​

Your backups will be stored in the target bucket following these formatting:

<SAP_SID>/<DB>/<year>/<month>/<day>/<SID>.DB.<start_date><start_time>.<dump_file>

All backup files from the same backup will have the exact same suffix. These can help you to identify the objects of a specific backup.

Example: HDB/SYSTEMDB/2020/05/01/D04.DB.20210713.164512.003