Backup for HANA system

Home

Requirement : You want to perform ad hoc HANA database backup.

Prerequisite : You need a HANA database user with BACKUP OPERATOR or BACKUP ADMIN role assigned.

Step :
Launch HANA studio and Open Administration perspective,  You can open it from Window > Open > Perspective > Administration Console.
Connect to your HANA system. In our case its K2K system.

Now select "Backup up system" from the context menu of backup node(shown below).

It will launch the backup wizard and will use the default Backup destination and Backup prefix parameter. The default backup destination path can be changed by changing following parameters in global.ini >persistence.
basepath_databackup = $(DIR_INSTANCE)/backup/data (default value)
Make changes to these default values if required and press next.

Review the information in next screen and press 'Finish'.

Now the backup is started and wizard will show you the progress for each service backup

Once the backup is finished , it will create following files at OS level. Note the number of files generated.

One can also trigger backup by executing the following SQL in SQL console.

BACKUP DATA USING FILE ('/usr/sap/K2K/HDB00/backup/data');

Note : Backup using SQL statements is only recommended for batch mode.