HDBSQL Example: Performing SAP HANA Backups on a Multitenant SYSTEMDB database

Perform a full backup of an online SAP HANA multitenant SYSTEMDB database by using the HDBSQL command line interface.

Best Practice: Use the timestamp for the backup prefix to ensure that there is a unique prefix.

Before You Begin

1. Log onto the database with BACKUP OPERATOR privileges.

2. The database must be online and all services must be running.

Procedure

• Create the following sample SQL Statement, substituting the parameters. Use a unique backup prefix.

   
  hdbsql -t -U $[user_store_key] “backup data for $[SYSTEMDB] using backint (‘$[YYYY_MM_DD:HH]:$[MM_BACKUP_FILE]’)”

Example

Perform a backup with the following parameters:

hdbsql -t -U $[BACKUPM] “backup data for $[SYSTEMDB] using backint ($[‘2015-07-07:09:50:00_COMPLETE_DATA_BACKUP’])”