Backup

You can use SAP HANA Studio, SAP HANA Cockpit, or SAP HANA HDBSQL to back up the data.

Log backup can be triggered periodically after automatic backup is configured. Catalog can be automatically backed up when Backint Agent is deployed. For details about the configuration methods, see Configuring SAP HANA.

The following use a case where SAP HANA Studio is used to back up SAP HANA 2.0 and Backint Agent is deployed to make full backup for data, catalog, and log and store the backups to OBS as an example to describe the backup procedure.

1. Open SAP HANA Studio, right-click the system to be backed up on the left, choose Backup and Recovery, and select an option based on the actual requirements:

• Back Up System Database
• Back Up Tenant Database

2. For example, to back up a tenant database, select a tenant database and set Destination Type to Backint. You can customize Backup Prefix.

3. Confirm the backup information and click Finish. If the installation and configuration are successful, the backup progress is displayed until the backup is complete.

4. After the backup is complete, you can query the backup in OBS. You can view the backups through OBS Browser+ or go to the Object Storage Service console to view the backups. The backup directories are as follows:

• System data backup directory: obs://{BUCKET}/usr/sap/{SID}/SYS/global/hdb/backint/SYSTEMDB
• Tenant data backup directory: obs://{BUCKET}/usr/sap/{SID}/SYS/global/hdb/backint/DB_{Tenant name}

5. After accessing the preceding directories, you can find the corresponding backup files based on Backup Prefix you set. Examples of file names for different types of backups are as follows:

• Full data backup: {Backup Prefix}_databackup_x_x.
• Incremental data backup: {Backup Prefix}_databackup_incremental_x_xxxxx_xxxxx
• Differential data backup: {Backup Prefix}_databackup_differential_x_xxxxx_xxxxx
• Catalog backup: log_backup_0_0_0_0
• Log backup: log_backup_x_0_xxxxx_xxxxx

You can view the backup files in different directories. You can find the corresponding backup files based on the backup time and backup ID. If the corresponding files are found, the backup is successful. The following backup file directory is an example.

obs://xxx/usr/sap/S99/SYS/global/hdb/backint/DB_S30/COMPLETE_DATA_BACKUP_databackup_2_1/1626157625497.bak