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
- Perform a full backup.
- Create the hbduserstore key.
- Log on to the database with the key.
- 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')"