Posts

Showing posts from July, 2012

DPM 2010 Tape Belongs to a DPM server sharing this library

I wrote a powershell script to fix this issue in 2010, it does not appear to be an issue in 2012.
a full explanation i got from here. Enjoy


$ServerInstance = "DPMSERVER\MSDPM2012" $Database = "DPMDB"




$ConnectionTimeout = 30 $Query = "select media.BarcodeValue, media.SlotNum, media.MediaId, gmedia.MediaPoolId from tbl_MM_Global_ArchiveMedia gmedia  inner join tbl_MM_Media media on gmedia.MediaId = media.GlobalMediaId " $QueryTimeout = 120 $conn=new-object System.Data.SqlClient.SQLConnection $ConnectionString = "Server={0};Database={1};Integrated Security=True;Connect Timeout={2}" -f $ServerInstance,$Database,$ConnectionTimeout $conn.ConnectionString=$ConnectionString $conn.Open() $cmd=new-object system.Data.SqlClient.SqlCommand($Query,$conn) $cmd.CommandTimeout=$QueryTimeout $ds=New-Object system.Data.DataSet $da=New-Object system.Data.SqlClient.SqlDataAdapter($cmd) [void]$da.fill($ds)  $conn.Close()



$Query2 = "select library.ProductId, libr…