HDBSQL Example: Performing SAP HANA Differential Backups

Perform a differential 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 DIFFERENTIAL using backint('backup_prefix')"

Last modified: 3/23/2018 3:40:24 PM