HANA Database backup Part 2 | differential backups and incremental backups

Published: 05 June 2021
on channel: SAP Administration learning platform

1,681

Please visit our blog to get more knowledge.

rupeshschavan.blogspot.com

SAP HANA supports backup types:

(1) Full backups:

1: Complete data backups -- A data backup includes all the data that is required to recover the database to a consistent state.
2: Data snapshots

Note

1: To ensure the safety of your data, data backups should be stored on multiple different backup destinations outside the SAP HANA database.

2: A data backup does not include the log area or customer-specific configuration settings (*.ini files).

(2) Delta backups (incremental backups and differential backups)

Delta backups contain only the data that has been changed since the last full data backup (complete data backup or data snapshot)
or the last delta backup.

1: reduce the amount of data
2: faster to create
3: faster database recovery
4: Less CPU utilization of database recovery

(3) Redo log backups

(4) Native encryption of backups

(5) Backups created using third-party backup tools