SAP HANA - Backup & Recovery - SAP HANA

What is SAP HANA Backup & Recovery?

SAP HANA backup and recovery is used to perform HANA system backups and recovery of system in case of any database failure.

Overview Tab

It tells the status of currently running data backup and last successful data backup.


Backup now option can be used to run data backup wizard.

Configuration Tab

It tells about the Backup interval settings, file based data backup settings and log based data backup setting.


Backup Interval Settings

Backint settings give an option to use third party tool for data and log back up with configuration of backing agent.

Configure the connection to a third-party backup tool by specifying a parameter file for the Backint agent.


File and Log Based Data Backup Settings

File based data backup setting tells the folder where you want to save the data backup on HANA system. You can change your backup folder.
You can also limit the size of data backup files. If system data backup exceeds this set file size, it will split across the multiple files.


Log backup settings tell the destination folder wherein you want to shop log backup on the external server. you may select a vacation spot kind for log backup

file − ensures that sufficient space in the system to store backups

Backint − is special named pipe exists on report system but require no disk space.

You can choose backup interval from drop down. It tells the longest amount of time that can pass before a new log backup is written. Backup Interval: It can be in seconds, minutes or hours.

Enable Automatic log backup option: It helps you to keep log area vacant. If you disable this log area will continue to fill and that can result database to hang.

Open Backup Wizard − to run the backup of system.

Backup wizard is used to specify backup settings. It tells the Backup type, destination Type, Backup Destination folder, Backup prefix, size of backup, etc.


When you click on next → Review Backup settings → Finish


It runs the system backups and tells the time to complete backup for the each server.

Recovery of HANA System

To recover SAP HANA database, the database needs to be shut down. Hence, during recovery, end users or SAP applications cannot access the database.

Recovery of SAP HANA database is required in the following situations −

  • A disk in the data area is unusable or disk in the log area is unusable.
  • As a consequence of a logical error, the database needs to be reset to its state at a particular point in time.
  • You want to create a copy of the database.

How to recover a HANA system?

Choose HANA system → Right click → Back and Recovery → Recover System.


Types of recovery in HANA machine

Most recent state − Used for improving the database to the time as near as feasible to the present day time. For this restoration, the data backup and log backup ought to be to be had since last records backup and log region are required to perform the above kind healing.

Point in Time − Used for recovering the database to the unique factor in time. For this restoration, the information backup and log backup have to be available since last data backup and log area are required to carry out the above type healing

Specific data Backup − Used for recovering the database to a specified data backup. specific data backup is needed for the above form of restoration alternative.

Specific Log position − This restoration type is an advanced option that can be used in awesome cases where a previous recuperation failed.

Note− to run restoration wizard you must have administrator privileges on HANA system.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status