How to Enable or Disable Automatic Log Backup in SAP HANA

Task:

 How to Enable or Disable Automatic Log Backup in SAP HANA

 Solution:

 By default SAP HANA creates redo log backups. You can enable or disable from HANA studio.

There are two ways to disable or enable Automatic Log backup.
 a. from Backup console
 b. from Configuration tab in HANA studio.
 1. Backup Console
 a. go to HANA STUDIO



b. Double click on



c. You will see below screen



d. Click on “Configuration”



e. You will see below screen



 f. You will have to check or uncheck “Enable Automatic Log Backup” option to enable or disable
 Automatic Log backup.


g.Now we see other way to enable or disable automatic Log backup.


2. From configuration tab in HANA studio.
 a. Go to HANA studio



b. Double click on HANA server SID.



c. You will see below screen



d. Click on “Configuration” tab



e. You will see below screen



f. Type “enable_auto_log_backup” in Filter Filed



g. You will see below screen



h. Double click on “enable_auto_log_backup” in the above screen. You will see below screen.



i. Now you need to specify Yes or NO to enable or disable automatic log backup.



j. And click on “SAVE” to save the option.

SAP HANA DB restart is not required. Changes takes effect immediately.