You should have to to uninstall the DP before server decommisioned,
IF the server was already decommissioned then there is no method to uninstall the DP from console. <o:p></o:p>
make sure the package and applications are removed from the DP. <o:p></o:p>
following query you can use,<o:p></o:p>
Note:- Using SQL query to remove anything is not supported and not recommended. these query are as is, no warranty
Delete from pkgservers where NALpath like '%\\DP%' and pkgID=''
Delete from pkgstatus where pkgserver like '%\\DP%' and ID=''
Delete from contentdpmap where serverpath like '%\\Dp%' and contentID=''
delete from PkgServers_L where NALPath like '%DP%' and pkgID=''
delete from PkgStatus_l where PkgServer like '%DP%' and ID=''
Delete from SC_SysResUse where NALPath like '%dp%'
Delete from SysResList where ServerName like '%DP%'
Delete from SC_SysResUse where NALPath like '%DP%'
Delete from v_DistributionPoint where ServerNALPath like '%DP%'
Delete from PkgServers where NALPath like '%DP%'
Delete from PkgStatus where Location like '%DP%'
Delete from DistributionContentVersion where DPNALPath like '%DP%'
Delete from DistributionStatus where DPNALPath like '%DP%'
Delete from DPGroupMembers where DPNALPath like '%DP%'
Delete from DistributionPoints where NALPath like '%DP%'
<o:p></o:p>
Sharad Singh | My blogs: SharadTech | Twitter:
@SinghSharaad | | Please remember to click “Mark as Answer” on the post that helps you.This can be beneficial to other community members reading the thread.
