How to take Incremental /differential backup in hana using command line

To create delta backups, you can use SAP HANA Studio or SQL commands

saphanawiki

How To Take Incremental Backup in HANA using SQL commands

BACKUP DATA INCREMENTAL USING FILE ('2016-07-23')

Creates an incremental backup based on the last data backup.

The names of the resulting backups are made up as follows:

<prefix>_‘databackup_incremental’_<ID of the data backup>_<ID of the incremental backup>_<volume ID>_<partition ID>

The example SQL statement would create backups with the following names:

Jul 23 09:57 2016-07-23_databackup_incremental_1426237023821_1426237028496_0_1

Jul 23 09:57 2016-07-23_databackup_incremental_1426237023821_1426237028496_1_1

Jul 23 09:57 2016-07-23_databackup_incremental_1426237023821_1426237028496_2_1

Jul 23 09:57 2016-07-23_databackup_incremental_1426237023821_1426237028496_3_1

How To Take DIFFERENTIAL Backup in HANA using SQL commands

BACKUP DATA DIFFERENTIAL USING FILE ('2016-07-23')

Creates a differential backup based on the last data backup.

The names of the resulting backups are made up as follows:

<prefix>_‘databackup_differential’_<ID of the data backup>_<ID of the differential backup>_<volume ID>_<partition ID>

The example SQL statement would create backups with the following names:

Jul 23 10:09 2016-07-23_databackup_differential_1426237023821_1426237780534_0_1

Jul 23 10:09 2016-07-23_databackup_differential_1426237023821_1426237780534_1_1

Jul 23 10:09 2016-07-23_databackup_differential_1426237023821_1426237780534_2_1

Jul 23 10:09 2016-07-23_databackup_differential_1426237023821_1426237780534_3_1

Creating a delta backup using SAP HANA Studio
1. In the Systems view in SAP HANA Studio, right-click on the system and choose Backup and Recovery
Backup System…
2. Choose the backup type, for a delta backup: either Differential Data Backup or Incremental Data Backup,
and specify further settings
3. Start the backup

 

Incremental And Differential backup in SAP HANA

Leave a Reply