HANA Database DATA Backup

by

You can trigger HANA Data Backup from

  1. HANA Cockpit
  2. From OS via HDBSQL
  3. HANA Studio

1. Hana Cockpit

2. From OS via HDBSQL

2.1 Trigger Backup from SYSTEMDB HDBSQL

To trigger tenant db backup you can either login to SYSTEMDB or TENANT DB.

You can use the below command to trigger the backup from HDBSQL. HDBSQL prompt will not end until your backup is successfully completed or failed with error.

hdbsql SYSTEMDB=> BACKUP DATA FOR HD2 USING FILE ('/hana/backup','full_backup');

You can use keyword “asynchronous” it will trigger the backup in the background. We can close the hdbsql console after it is triggered. 

hdbsql SYSTEMDB=> BACKUP DATA FOR TP1 USING FILE ('/hana/backup','full_backup') asynchronous;

Trigger the backup from Tenant DB

If you are triggering the backup from tenant db use the below command. First argument is backup destination”/hana/backup”, second argument is prefix of the backup “full_backup”.

hdbsql TP1=> BACKUP DATA USING FILE (‘/hana/backup’,’full_backup’);

Once you backup is completed your backup file name would be full_backup_databackup_.._..

3. HANA Studio

Leave a Comment