+1Hi 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;
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,
+1Thanks for the reply. Will your suggestion still work if 100 GB were deleted and 100 GB were inserted since that last backup?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
