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
- 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 DIFFERENTIAL using backint('backup_prefix')"
Last modified: 3/23/2018 3:40:24 PM