Backup & Recovery

After Every initial load it is recommended to take backup of ‘data area’, ‘log area’, and ‘configuration files’.

i) Backup of data area:This is done from persistent stage to external backup   location

ii) Backup of log area: This is automatic activity by the system scheduler where we have to define level of logs to be captured.

iii)  Backup of configuration files:   Here we have all landscape settings, DB settings, privileges settings etc., in .INI file which is to be backuped manually.

1v) To take backup the user should have two privileges

a) Backup – ADMIN

b) CATALOG – READ, Backup – Admin

v) Process for taking BACKUP

Log on to HANA Studio.

Right click on DB System

Select backup option

Provide base path where you take back up

(Which is already defined in global .INI file)

Interested in mastering SAP HANA Certification? Enroll now for FREE demo on SAP HANA Training Online.


To recover the system from failure it will ask you to shut down after the recovery point.

Go to HANA Studio  Untitled  Administrator   Untitled  Recovery    Untitled   Select system   Untitled  restart

Option Untitled  select recovery point.

1) Recovery to a specified point of time

2) Recovery to a specified log position

3) Recovery of a specific data backup

Recovery path

/usr/sap/HAN/HDB 52/backup/data


In the Admin console:

When you open HANA Studio you have to connect the HANA DB further

We have to night click on the mode & click an add system

Host Name         ____________

Instance Number            ­­__________

Description        ____________

Locale                  __________

Add to folder     __________

To export the development landscape to testing & production

First we have to create landscape to testing and production frost we have to create landscape.

XML file exporting later we can find import the same on quality & production

We can ‘stop & Restart’ the DB system from HANA studio

In HANA studio ‘load / unload’ option will allow you to commit the data Ram into main memory.

For an Indepth knowledge on SAP HANA, click on below