> CommCell Console > Backup and Restore Agents > Databases > SAP > SAP HANA > SAP HANA Agent Backup Operations > SAP HANA Backup Examples Using the HDBSQL Command Line Interface

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.

Procedure

  • 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')"

Page contents

×

Loading...