HANA DB backup using HANA studio

what is contained in the backup file?

The data backup includes not only data, but also data structure that are required for restore of DB.

why to take backup on regular basis?

To save data during disk failures

Pre-requsites:

DB user with roles: Backup Admin
                                Backup Operator

                                Catalog read

Note: same roles are enough for performing the recovery of HDB also.

SQL query for check the backup size:

select sum (allocated_page_size) from M_converter_Stastistics

select volume id, sum (allocated_page_size) from M_Converter_Stasticstics) group by volume id,

based on the out put of the above query --> make space arrangements.

Process:

Method1

• Open HANA studio.
• select the correct system for backup amomgs all systems.
• Right click
• choose backup
• choose type as full / differential /incremental 
• specify the location and prefix for the backup file.
• conform 

Method 2

• Open HANA studio.
• login to system
• open hdbsql
• execute the query:

BACKU DATA USING FILE ('/usr/sap/<SID>/HDBXX/backup/data')