Backup-Set Size

[siccness]

Hi all,

I was wondering if there's a way to determine the size of a successfully completed backup-set?

We recently completed a backup-set and it was written to about 10 tapes (400GB in size); however, I don't think it's too accurate because the amount of data should not have really exceeded more than 800GB.

Thanks in advance!

Kind regards,

siccness

 

[picay]

select node_name, sum(logical_mb) as Data_In_MB, sum(num_files) as Num_of_files from occupancy where node_name='YOUR_NODE'

 

[DanGiles]

No, that won't work because backup sets only contain the active data at the time the set was generated. So, on a 'normal' file server, the size of the backup set should be <= the amount of data on the server.

There are a number of reasons you may see more than you are expecting: are you compressing at the client? Do you do image backups? Are you using TDP agents with the same name as the client node?

 

[picay]

select cast(capacity/100*pct_util as integer) from filespaces where node_name='YOUR_NODE'
will give you approx the size in MB of filesystems on the client
as there are maybe some exclusions, you will have the greatest size in MB for active data's
is hard compression enabled on the drive ?

 

[picay]

to estimate active data size, you can also try an export preview=y
on the generate backupset command, check if you used datatype correctly for your purpose
About tdp data's, only exchange and sql can be included in a backupset
node_name is unique on tsm server