This blog will be about a new feature in HANA SP10, delta backups.
What is a Delta Backup?
Starting with SPS 10 delta backups were introduced, this feature allows users to perform backup and recoveries quicker. Delta backups only capture the data changed since the last backup or delta backup, meaning less log backups are read for a recovery.
There are two options available when creating a delta backup:
Differential Backup - stores all data changed since the last full backup.
Incremental Backup - Stores the data changed since the last full or last delta backup. These backups are smaller than the differential backups.
How to Create a Delta Backup?
First choose a user that has the BACKUP ADMIN authorization, in this case we will be using the SYSTEM user.
Right click on the system you would like to create a backup for
What is a Delta Backup?
Starting with SPS 10 delta backups were introduced, this feature allows users to perform backup and recoveries quicker. Delta backups only capture the data changed since the last backup or delta backup, meaning less log backups are read for a recovery.
There are two options available when creating a delta backup:
Differential Backup - stores all data changed since the last full backup.
Incremental Backup - Stores the data changed since the last full or last delta backup. These backups are smaller than the differential backups.
How to Create a Delta Backup?
First choose a user that has the BACKUP ADMIN authorization, in this case we will be using the SYSTEM user.
Right click on the system you would like to create a backup for
