How to take delta backup in HANA

Use the below procedure to trigger the Delta Backup in HANA DB

  1. Take Delta Backup(Incremental/Differential) from HDBSQL
  2. Take Delta Backup(Incremental/Differential) from HANA Cockpit
  3. Take Delta Backup(Incremental/Differential) from HANA Studio

Take Delta Backup(Incremental/Differential) from HDBSQL

BACKUP DATA INCREMENTAL FOR USING FILE (‘/backup/hana’, ‘prefix_description’);

BACKUP DATA DIFFERENTIAL FOR USING FILE (‘/backup/hana’, ‘prefix_description’);

Take Delta Backup(Incremental/Differential) from HANA Cockpit

Navigate to “Database Management”

Select the tenant db which needs to be backed up and select Backup Tenant option in the Actions.

Click on create backup

Choose the backup type, give the backup destination and start the backup

Leave a Comment