SAP Hana backup size Estimation

It is important to ensure that sufficient free space is available for backups. If there is not enough space, a backup will fail. For this reason, before you back up the database, you should estimate the amount of space that will be needed in the backup destination.

To estimate the size of the next full data backup (but not a delta backup), you can use either of the following commands:

Requirement : We want to check the backup size, so that we can plan for the backup disk requirement.

Prerequisite: We need database user with CATALOG READ or DATA ADMIN assigned.

Please follow the below Steps: 

Step 1: Connect to the required system via HANA Studio.

Step 2: Open Administration perspective,  You can open it from Window -> Open -> Perspective -> Administration Console

Step 3: Execute following SQL:

SELECT SUM(allocated_page_size) FROM M_CONVERTER_STATISTICS

Note: Above SQL will let us know the total backup size in bytes:

Step 4:  ( query to Estimate Space)  If you want to see the size of individual HANA service then execute following SQL.

SELECT volume_id, sum(allocated_page_size) FROM M_CONVERTER_STATISTICS GROUP BY volume_id;

The size displayed is in BYTES. Above shown Volume_ID are mapped with services(shown below).

Backup file Naming Convention in HANA Studio

HANA Server	Volume ID assigned	Example file name
Name Server – Topology	0	databackup_0_1
Name Server – Volume	1	databackup_1_1
Index Server	2	databackup_1_2
Statistics server	3	databackup_1_3
XS engine	4	databackup_1_4

Note: in the above example complete is file name prefix and the databackup_0_1 is the Suffix!!!!!!