Backup & Recovery

What is a consolidated log backup in SAP HANA, and what is its default and maximum size?

When SAP HANA backs up via a third-party tool (Backint), how is the data passed, and can the destination path be changed?

What does the SAP HANA backup catalog contain, and what is the consequence of recovering without it?

How can you estimate the size needed for an SAP HANA file-system backup before running it?

What is the performance cost of SAP HANA backup encryption, and which parameter trades throughput for lower impact?

What is the difference between a database-aware and a database-unaware snapshot in SAP HANA?

What four recovery modes (target points) does the SAP HANA recovery procedure support?

What happens to the SAP HANA license after a database recovery onto a different system or host?

In a scale-out (multihost) SAP HANA system, how is a file-system backup performed across the nodes?

Can an SAP HANA backup from a single-tenant database be recovered into a tenant of a multitenant system, and vice versa?

Where are SAP HANA file-based data backups written by default, and which parameter changes the location?

What is the SQL workflow to create and confirm an SAP HANA data snapshot?

Compare SAP HANA's three backup targets (file, Backint third-party, data snapshot) on deduplication, backup size, and speed.

What is the scope of an SAP HANA database backup, and what does a recovery always apply to?

What is the basic syntax of the SAP HANA `BACKUP DATA` statement, and how do you target a specific tenant from the system database?

How does automatic log backup work in SAP HANA, and what does `log_backup_interval_mode` control?

What is the only recovery option for a logical/human error (e.g. data deleted by mistake) in SAP HANA, and why is it a last resort for production?

Which SAP HANA tools determine the backups needed for a recovery versus verify a backup's consistency without restoring it?

How do you remove old SAP HANA backups using the backup catalog, and what is the difference between two forms of BACKUP CATALOG DELETE?

Name three defining characteristics of how SAP HANA backups work (online, scope, independence).

Why does SAP recommend reserving disk space for at least two backups when backing up an SAP HANA database to a file?

What is the difference between a differential and an incremental delta backup in SAP HANA?

Why must SAP HANA configuration files be backed up separately from database backups, and where do they live?

Which SAP HANA tool rebuilds a lost or corrupted backup catalog, and what is missing from the rebuilt catalog?

In which three situations does SAP HANA save (back up) a log segment?

Which encryption standard does SAP HANA backup encryption use, and what key is involved?

Which three monitoring views report SAP HANA backup status, and what is special about M_BACKUP_PROGRESS?

After a takeover in an SAP HANA system-replication setup, what is the status of existing backups, and what is required before delta backups can be made on the new primary?

What is the difference between RPO and RTO in SAP HANA disaster recovery?

In what recovery scenario do you use the SAP HANA "Initialize Log Area" option, and what is its effect?

What is the correct restore sequence when recovering an SAP HANA database that uses full, differential, incremental, and log backups?

Why is disk persistence alone insufficient for SAP HANA, making backups necessary?

When recovering an entire multitenant SAP HANA system, in what order must the databases be recovered?

What are the four key characteristics of an SAP HANA data snapshot — regarding scope, content, integrity checking, and interface?

Why must SAP HANA system replication be reinitialized after a point-in-time recovery of the primary?

What are the three internal phases of an SAP HANA database recovery (sequence of activities)?

What does the SAP HANA backup retention policy control, and what is the default minimum number of retained generations?

What is the SAP HANA backup file naming convention, and what does the auto-added suffix encode?