Hana double backup notifications and no log backup for systemdb

[Salzi]

Hi all,

we are facing two issues.
Maybe by design or some misconfigurations on our side. (SAP/Veeam)

1. Issue - Hana double backup notifications
We are using Backint mode.
- As far as i understand this means Veeam manages all backup related stuff?

The Log intervall is set to 2h.
This is also configured in SAP HANA Studio which confuses me slightly.
- is it still neccessary to have "enable automatic log backups" on Hana Side activated? (is this maybe causing the doubled backup notifications?)

As for the logs it seems that there are more logs than one for every 2h. (is this normal)

-->

The mail notifications show a different initiator maybe this points in

2. issue - no log backup for systemdb
It seems that there are no log backups for systemdb.
Any ideas for that issue.

-->

for the other DB it looks like that...

-->

thx in advance and regards
Salzi

[PetrM]

Hi Salzi,

Unlike SQL Server, Oracle, or PostgreSQL protection, where we trigger log backups according to scheduled intervals, SAP HANA operates in Immediate log backup interval mode and runs log backups whenever it desires. Therefore, we can only apply settings once and monitor log backups by querying the SAP HANA backup catalog periodically and showing a warning if there is no new record for the last X minutes. Additionally, you can disable this monitoring and simply rely on the information in the backup catalog.

Answering your questions:

1. The setting in SAP HANA should remain unchanged, 2 hours means that it will perform log backups at least every 2 hours. However, if the log segment fills too quickly, it can run backups more frequently. There is a statement on this page about the log backup interval mode:

A log backup is created immediately after a log segment becomes full, or when the service-specific timeout for a log segment has been reached.

You may check the backup catalog on the SAP HANA side to ensure that it creates log backups more often than every 2 hours.

2. It states, "Cannot find any full backups" (see the line above in the action log in the screenshot). Let's wait for a full backup, after that, our monitoring job will start to work.

Thanks!