DPM and disk volumes

If you make use of Microsoft DPM for disk-based backups, you may find yourself wanting to identify which data sources are protected on the logical volumes on the disks in your storage pool.

If you open the Disk Management snap-in, you’ll see something like this:

volume-list

You can open the properties for the volume from the list, to view some details about it:

volume-properties

To find out which replicas are on which volumes, log on to the SQL instance for your DPM server and open SQL Server Management Studio. Once its open, start a new query in your DPM application database and run the following query:

select ag.NetbiosName, ds.DataSourceName, vol.MountPointPath, ds.DataSourceId, vol.GuidName
from tbl_IM_DataSource as ds
join tbl_PRM_LogicalReplica as lr
on ds.DataSourceId=lr.DataSourceId
join tbl_AM_Server as ag
on ds.ServerId=ag.ServerId
join tbl_SPM_Volume as vol
on lr.PhysicalReplicaId=vol.VolumeSetID
and vol.Usage=1
order by NetbiosName

If you want to limit this to a specific volume, execute the following statement, replacing the [GUID] tag with the GUID of the volume from its properties:

select ag.NetbiosName, ds.DataSourceName, vol.MountPointPath, ds.DataSourceId, vol.GuidName
from tbl_IM_DataSource as ds
join tbl_PRM_LogicalReplica as lr
on ds.DataSourceId=lr.DataSourceId
join tbl_AM_Server as ag
on ds.ServerId=ag.ServerId
join tbl_SPM_Volume as vol
on lr.PhysicalReplicaId=vol.VolumeSetID
and vol.Usage=1 and vol.MountPointPath like '%[GUID]%'
order by NetbiosName

For example:

select ag.NetbiosName, ds.DataSourceName, vol.MountPointPath, ds.DataSourceId, vol.GuidName
from tbl_IM_DataSource as ds
join tbl_PRM_LogicalReplica as lr
on ds.DataSourceId=lr.DataSourceId
join tbl_AM_Server as ag
on ds.ServerId=ag.ServerId
join tbl_SPM_Volume as vol
on lr.PhysicalReplicaId=vol.VolumeSetID
and vol.Usage=1 and vol.MountPointPath like '%0e411c99-f6b0-4423%'
order by NetbiosName

Share and Enjoy:
  • Digg
  • StumbleUpon
  • Technorati
  • del.icio.us
  • Twitter
  • blogmarks
  • HackerNews
  • Tumblr
  • Posterous
  • email
Bookmark the permalink. Follow any comments here with the RSS feed for this post.
Post a comment or leave a trackback: Trackback URL.

Leave a Reply

Your email address will not be published. Required fields are marked *

This blog is kept spam free by WP-SpamFree.