Options

Estimate Incremental Backup Size

avi120avi120 ✭
in General Discussion

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;
Tagged:

Answers

  • Options
    V_LearnerV_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,

  • Options
    avi120avi120 ✭

    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...