1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Backup-Set Size

Discussion in 'Backup / Archive Discussion' started by siccness, Aug 18, 2009.

  1. siccness

    siccness New Member

    Joined:
    Aug 18, 2009
    Messages:
    1
    Likes Received:
    0
    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
     
  2.  
  3. picay

    picay New Member

    Joined:
    Oct 22, 2004
    Messages:
    212
    Likes Received:
    0
    select node_name, sum(logical_mb) as Data_In_MB, sum(num_files) as Num_of_files from occupancy where node_name='YOUR_NODE'
     
  4. DanGiles

    DanGiles Senior Member

    Joined:
    Oct 25, 2002
    Messages:
    568
    Likes Received:
    10
    Occupation:
    Sr. Storage Admin
    Location:
    Toronto, Ont. Canada
    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?
     
  5. picay

    picay New Member

    Joined:
    Oct 22, 2004
    Messages:
    212
    Likes Received:
    0
    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 ?
     
  6. picay

    picay New Member

    Joined:
    Oct 22, 2004
    Messages:
    212
    Likes Received:
    0
    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
     

Share This Page