SAP HANA Data backups can include configuration files (ini-files) - SPS06 and above

Why it's required ?

Whenever you want to perform hardware move or system copy for your HANA system, including all the customer configurations which are set on ini files, you have to always copy them from source to target server. Let's consider another scenario, if you have to restore your HANA system with some previous point in time, because someone messed up with your current HANA existing configurations, that caused a major incident and your system is now unstable. You can recover the data, from last backups but your configurations are gone now unless and until you are also backing up config files separately.


What if HANA can take care of itself and you do not even need to bother about such critical configurations ? let's see it further.


What is changed ?

As of HANA 2.0 SPS06 onwards, content of the configuration files can be backed up with each (delta or full) data backup, and will be included in the metadata backup. Yes, you read it absolutely right.


Note :

- By default, a data backup does not include user configuration files (.ini files).

- Also by default, a recovery does not restore user configuration files.


How this works ?

To configure SAP HANA to include or exclude user configuration files, there are 2 ways to achieve it :


Include in HANA Configuration

In the backup section of the global.ini parameter file, locate the parameter include_configuration_backup.

include_configuration_backup = false
# this is an online configuration change, no DB restart is needed.

Note : The parameter can be overruled by the additional SQL options during a backup.