When you first connect HANA Studio to your HANA, express edition, you will be presented with 1 alert with HIGH priority:

HANA Cockpit paints the same picture:

Checking the Alert Details, you find that this is due to your Database does not support point-in-time recovery as current log mode is overwrite:

Since the HANA express edition is meant to be a sandbox system, you could of course not mind and switch off the Schedule in the respective Alert Checker Configuration if you were bothered by it:

However, if you wanted to learn and try how HANA logging and point-in-time recovery work, e.g. in preparation for a HANA certification, you could as well enable it. For this, you set the Log mode from overwrite back to its default value normal:

To prevent the log area from overflowing, you then also have to perform a full database backup to enable log backups:

Subsequently you see automatic log backups appearing in the Backup Catalog:

Depending on your system activity, these backups will be smaller or larger, but to prevent the file system from overflowing, from now on you would have to make regularly full database backups to be able to Delete Older Backups:

Alternatively, you could of course always switch back to Log mode overwrite.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Jesús López Urrabieta

    Thanks for the Entry.

    I tried this when I first saw the alert after installing HXE, but It doesn’t work for me. The log_mode is se to normal, I have done several complete backups, restarted the system… But the system value still is “overwrite”, the alert keeps poping up and there are not new generated incremental backups…

    I don’t know what I’m missing…

    (0) 

Leave a Reply