Estimate Size Of The Backup Easily With M_BACKUP_SIZE_ESTIMATIONS | SAP HANA

M_BACKUP_SIZE_ESTIMATIONS IN SAP HANA

 

M_BACKUP_SIZE_ESTIMATIONS view Provides the estimated size of the next data backup such as  complete data backup, data snapshot,  differential and incremental backups,log backup, log missing,

Example :

 

M_BACKUP_PROGRESS -To check Progress of the  the most recent backup.

 

select * from M_BACKUP_PROGRESS

| BACKUP_ID | HOST |SERVICE_NAM | ENTRY_TYPE_NAME | SYS_START_TIME | SYS_END_TIME |STATE_NAME | BACKUP_SIZE |
| ——————– | —————– |———– | ——————– | —————————–| —————————– |———- | ——————– |
| 1473677542853 | xxxxxxxxxxxxxxxxxx|xsengine | complete data backup | 2016-09-12 10:52:25.260000000| 2016-09-12 10:53:20.719000000 |successful | 83890176 |
| 1473677542853 | xxxxxxxxxxxxxxxxxx|indexserver | complete data backup | 2016-09-12 10:52:25.260000000| 2016-09-12 11:25:02.257000000 |successful | 243521294336 |
| 1473677542853 | xxxxxxxxxxxxxxxxxx|nameserver | complete data backup | 2016-09-12 10:52:25.260000000| 2016-09-12 10:53:22.685000000 |successful | 150999040 |
| 1473677542853 | xxxxxxxxxxxxxxxxxx|indexserver | complete data backup | 2016-09-12 10:52:25.260000000| 2016-09-12 11:21:42.452000000 |successful | 268620009472 |

Leave a Reply