Previously, I blogged about issues I was having where old recovery points were not being expired\/removed from my DPM servers. I had to open a ticket with Microsoft, and worked with them to determine the cause, and since then, they have released a fix.<\/p>\n
The fix that Microsoft developed is here: http:\/\/www.microsoft.com\/downloads\/details.aspx?FamilyID=aee949aa-d3e7-4b0f-b718-00b7c20f1257&displayLang=en<\/a><\/p>\n A few people have asked for the PowerShell script \u201cshow-pruneshadowcopies.ps1\u201d that Microsoft provided and I mentioned in my previous post (here)<\/a>. The script looks like this:<\/p>\n #displays all RP for data sources and shows which RP’s would be deleted by the regular pruneshadowcopies.ps1 #Author : Mike J $date=get-date function GetDistinctDays([Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.OMCommon.ProtectionGroup] $group, foreach($schedule in $scheduleList) return 0 function IsShadowCopyExternal($id) $ctx = New-Object -Typename Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlContext $cmd = $ctx.CreateCommand() return $result function IsShadowCopyInUse($id) $ctx = New-Object -Typename Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlContext $cmd = $ctx.CreateCommand() return $result "**********************************" > $logfile $dpmservername = &"hostname" <\/p>\n $dpmsrv = connect-dpmserver $dpmservername <\/p>\n if (!$dpmsrv) write-host $dpmservername write-host("Number of ProtectionGroups = {0}" -f $pgList.Length) foreach($pg in $pgList) if ($rplist) write-host "Number of RPs that would be deleted = $numberOfRecoveryPointsDeleted" disconnect-dpmserver $dpmservername exit <\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":" Previously, I blogged about issues I was having where old recovery points were not being expired\/removed from my DPM servers. I had to open a ticket with Microsoft, and worked with them to determine the cause, and since then, they have released a fix. The fix that Microsoft developed is here: http:\/\/www.microsoft.com\/downloads\/details.aspx?FamilyID=aee949aa-d3e7-4b0f-b718-00b7c20f1257&displayLang=en A few people… Continue reading Follow up to the DPM recovery point expiration issues<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6,17,33],"tags":[80,120,135,184],"class_list":["post-195","post","type-post","status-publish","format-standard","hentry","category-data-protection-manager","category-microsoft","category-system-center","tag-dpm","tag-microsoft","tag-powershell","tag-updates","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pcW544-39","_links":{"self":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/comments?post=195"}],"version-history":[{"count":0,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/195\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/media?parent=195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/categories?post=195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/tags?post=195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
# Outputs to a logfile: C:\\Program Files\\Microsoft DPM\\DPM\\bin\\SHOW-PRUNESHADOWCOPIES.LOG <\/p>\n
#Date : 02\/24\/2009
$version="V1.0" <\/p>\n
$logfile="SHOW-PRUNESHADOWCOPIES.LOG.txt" <\/p>\n
[Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.OMCommon.Datasource] $ds)
{
if($group.ProtectionType -eq [Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.OMCommon.ProtectionType]::DiskToTape)
{
return 0
}
$scheduleList = get-policyschedule -ProtectionGroup $group -ShortTerm
if($ds -is [Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.FileSystem.FsDataSource])
{
$jobType = [Microsoft.Internal.EnterpriseStorage.Dls.Intent.JobTypeType]::ShadowCopy
}
else
{
$jobType = [Microsoft.Internal.EnterpriseStorage.Dls.Intent.JobTypeType]::FullReplicationForApplication
if($ds.ProtectionType -eq [Microsoft.Internal.EnterpriseStorage.Dls.Intent.ReplicaProtectionType]::ProtectFromDPM)
{
return 2
}
}
write-host "Look for jobType $jobType" <\/p>\n
{
write-host("schedule jobType {0}" -f $schedule.JobType)
if($schedule.JobType -eq $jobType)
{
return [Math]::Ceiling(($schedule.WeekDays.Length * $ds.RecoveryRangeinDays) \/ 7)
}
} <\/p>\n
} <\/p>\n
{
$result = $false; <\/p>\n
$ctx.Open() <\/p>\n
$cmd.CommandText = "select COUNT(*) from tbl_RM_ShadowCopy where shadowcopyid = ‘$id’"
write-host $cmd.CommandText
$countObj = $cmd.ExecuteScalar()
write-host $countObj
if ($countObj -eq 0)
{
$result = $true
}
$cmd.Dispose()
$ctx.Close() <\/p>\n
} <\/p>\n
{
$result = $true; <\/p>\n
$ctx.Open() <\/p>\n
$cmd.CommandText = "select ArchiveTaskId, RecoveryJobId from tbl_RM_ShadowCopy where ShadowCopyId = ‘$id’"
write-host $cmd.CommandText
$reader = $cmd.ExecuteReader()
while($reader.Read())
{
if ($reader.IsDBNull(0) -and $reader.IsDBNull(1))
{
$result = $false
}
}
$cmd.Dispose()
$ctx.Close() <\/p>\n
} <\/p>\n
"Version $version" >> $logfile
get-date >> $logfile <\/p>\n
{
write-host "Unable to connect to $dpmservername"
exit 1
} <\/p>\n
"Selected DPM server = $DPMservername" >> $logfile
$pgList = get-protectiongroup $dpmservername
if (!$pgList)
{
write-host "No PGs found"
disconnect-dpmserver $dpmservername
exit 2
} <\/p>\n
$replicaList = @{}
$latestScDateList = @{} <\/p>\n
{
$dslist = get-datasource $pg
if ($dslist.length -gt 0)
{
write-host("Number of datasources in this PG = {0}" -f $dslist.length)
("Number of datasources in this PG = {0}" -f $dslist.length) >> $logfile
}
Foreach ($ds in $dslist)
{
write-host("DS NAME= $ds")
("DS NAME= $ds") >>$logfile
}
foreach ($ds in $dslist)
{
$rplist = get-recoverypoint $ds | where { $_.DataLocation -eq ‘Disk’ }
write-host("Number of recovery points for $ds {0}" -f $rplist.length)
("Number of recovery points for $ds {0}" -f $rplist.length) >>$logfile
$countDistinctDays = GetDistinctDays $pg $ds
write-host("Number of days with fulls = $countDistinctDays")
("Number of days with fulls = $countDistinctDays") >>$logfile
if($countDistinctDays -eq 0)
{
write-host "D2T PG. No recovery points to delete"
"D2T PG. No recovery points to delete" >>$logfile
continue;
}
$replicaList[$ds.ReplicaPath] = $ds.RecoveryRangeinDays
$latestScDateList[$ds.ReplicaPath] = new-object DateTime 0,0
$lastDayOfRetentionRange = ([DateTime]::UtcNow).AddDays($ds.RecoveryRangeinDays * -1);
write-host("Distinct days to count = {0}. LastDayOfRetentionRange = {1} " -f $countDistinctDays, $lastDayOfRetentionRange)
("Distinct days to count = {0}. LastDayOfRetentionRange = {1} " -f $countDistinctDays, $lastDayOfRetentionRange) >>$logfile
$distinctDays = 0;
$lastDistinctDay = (get-Date).Date
$numberOfRecoveryPointsDeleted = 0 <\/p>\n
{
foreach ($rp in ($rplist | sort-object -property UtcRepresentedPointInTime -descending))
{
if ($rp)
{
if ($rp.UtcRepresentedPointInTime.Date -lt $lastDistinctDay)
{
$distinctDays += 1
$lastDistinctDay = $rp.UtcRepresentedPointInTime.Date
}
write-host(" $ds")
(" $ds") >>$logfile
write-host(" Recovery Point #$distinctdays RPtime={0}" -f $rp.UtcRepresentedPointInTime)
(" Recovery Point #$distinctdays RPtime={0}" -f $rp.UtcRepresentedPointInTime) >>$logfile
if (($distinctDays -gt $countDistinctDays) -and ($rp.UtcRepresentedPointInTime -lt $lastDayOfRetentionRange))
{
write-host ("Recovery Point would be deleted ! – RPtime={0}" -f $rp.UtcRepresentedPointInTime) -foregroundcolor red
("Recovery Point would be deleted ! – RPtime={0} <<<<<<<" -f $rp.UtcRepresentedPointInTime) >>$logfile
#remove-recoverypoint $rp -ForceDeletion -confirm:$true | out-null
$numberOfRecoveryPointsDeleted += 1
}
else
{
write-host " Recovery point not expired yet"
" Recovery point not yet expired" >>$logfile
}
}
else
{
write-host "Got a NULL rp"
"Got a NULL rp" >>$logfile
}
} <\/p>\n
"Number of RPs that would be deleted = $numberOfRecoveryPointsDeleted" >>$logfile
}
}
} <\/p>\n
write-host "Exiting from script" <\/p>\n