Adhoc or on demand Backup in Hana

We can perform manual backups on SAP HANA database as and when required using SQL commands or by SAP HANA Studio. Backup commands are executed on a SAP HANA database system as a user having BACKUP_ADMIN privileges.

Manual Backup example as below

-----------Command : BACKUP DATA ALL USING FILE ('COMPLETE')----------------------

hdbsql  -i 02 -u system -p a1234   "backup data using file ('xyz/hdb/SID/backup/data')"

hdbsql -i 02 -u system -p a123      "BACKUP DATA ALL USING FILE ('xyz/hdb/SID/backup/data/BEFORE_UPGRADE_FULL')" 

Using above SQL command we can perform data backup for a HANA instance which creates data backup files for every service.

Data backup files will be labeled with leading string ‘COMPLETE’. Therefore the following backup files will be created:

databackup_0_1 (contains topology)

databackup_1_1 (contains name server persistency)

databackup_2_1 (normally contains index server persistency)

databackup_3_1 (normally contains statistic server persistency)