CODEWITHSUNDEEP
hanahana-sql-scripthana-studio
Bruno Avellaneda
Bruno Avellaneda

Reputation: 1

SAP HANA, query to check the size of the FullBackup as displayed in the HANA Studio backup catalog

I need help in creating an SQL query that can retrieve the size occupied by the latest FullBackup in HANA Studio. I haven't been able to find this SQL query in any forum or SAP note. Any ideas on how to obtain this value?

Example :

SELECT TOP 1 STATE_NAME, BACKUP_SIZE 
FROM SYS.M_BACKUP_CATALOG 
WHERE entry_type_name = 'complete data backup' 
ORDER BY ENTRY_ID DESC;

Specifically, the value I want to obtain is the one shown in the following image:

This value need

Thank you in advance.

Upvotes: 0

Views: 559

Answers (1)

冯际成
冯际成

Reputation: 1

hello You may need M_BACKUP_CATALOG_FILES view access to information

You can refer to the SAP Note 1969700 script

Upvotes: 0

Related Questions