Estimate Incremental Backup Size

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;


  • Options

    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,

  • Options

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file