Estimate Incremental Backup Size

avi120

Hi all,

I know I can run the following query to get an estimation of full backup size. However, can I possibly estimate the backup size of an incremental backup that is executed after we already backed-up the database few days ago.

 select node_name, sum(used_bytes) / ( 1024^3 ) as size_in_gb 
 from v_monitor.storage_containers 
 group by node_name;

V_Learner

Hi,
You could probably try to archive the data of the storage_containers table into a separate schema for yesterday's data, and compare it with today's size. You will see the change in the size of the same to check the incremental backup size,

avi120

Thanks for the reply. Will your suggestion still work if 100 GB were deleted and 100 GB were inserted since that last backup?