HDBSQL Example: Performing SAP HANA Complete Data Backups

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

Best Practice: Use the timestamp for the backup prefix. This ensures that the prefix is unique.

Before You Begin

1. Create the hbduserstore key.

2. Log on to the database with the key.

3. 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 -U user_store_key "backup data using backint ('$(date '+%Y_%m_%d_%H_%M')_BACKUP_FILE')"