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’)”