V11 SP8

HDBSQL Example: Performing SAP HANA Incremental Backups

Perform an incremental 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.

Note: You must have SAP HANA SPS 10 or higher in order to perform an incremental or differential backup.

Before You Begin

  1. Perform a full backup.
  2. Create the hbduserstore key.
  3. Log on to the database with the key.
  4. The database must be online and all services must be running.


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

hdbsql -U user_store_key "backup data INCREMENTAL using backint('backup_prefix')"