Find size of a Protection Group Or Protection Group sets RRS feed

  • Question

  • I am using Co-location Protection Group set to backup multiple Protection groups to single tape. I want to know the size of co-location protection Group sets to make sure it won't exceed the tape size.

    Need help to find the Script or way to get that estimate.


    Tuesday, November 22, 2016 9:44 AM

All replies

  • Hi,

    The amount of data that will be backed up to tape will be very close to the amount of used space on the replica volume for each data source in the protection group(s) in the co-location set.  You can use the below SQL script to list each replica volume used space by data source.  One thing to look out for is some data sources like SQL DB,s, Hyper-v VM's and client protection can be co-located on the same replica, so you don't want to count those replica's more than once.

    Start a new SQL query window, select the DPMDB  then copy and paste the query and run it.  Look for the data sources that are in the same tape co-location set and total the replica used size for them.  That will be the amount of data copied to tape for each tape backup.  If you have tape compression enabled then that will skew the numbers and would assume a 2:1 ratio.

    select server.servername,datasource.datasourcename,
    round (replicavol.ReplicaUsedSize/1024.0/1024.0/1024.0,2) as "ReplicaUsed in GB", 
    Volume.GuidName as "Replica volume GUID"
    from tbl_SPM_Volume Volume 
    join tbl_SPM_VolumeSet VolumeSet on VolumeSet.VolumeSetId=Volume.VolumeSetId 
    join tbl_PRM_LogicalReplica Replica on Replica.PhysicalReplicaId=VolumeSet.VolumeSetId 
    join dbo.tbl_PRM_ReplicaVolume ReplicaVol on VolumeSet.VolumeSetId=replicavol.ReplicaId 
    join tbl_IM_Datasource Datasource on Datasource.DatasourceId=Replica.DatasourceId 
    join tbl_AM_Server Server on Server.ServerId=Datasource.serverid 
    and Replica.Validity in (1,2)   
    and volume.usage in (1) 
    order by Volume.GuidName 

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, November 22, 2016 7:00 PM
  • Since I am backing up mostly SQL databases and therefore there are more than one replica's available for same server. Is there way to filter this through SQL query ?

    Tuesday, February 28, 2017 5:13 PM