HowTo Remove Orphan Distribution Points

[wmmayms]

Hi Guys

 

Thought id share this with you, since its a pretty common problem after removing a distrubution point from site systems.

When doing this you must first remove the DP from every package in your enviroment. But people don´t do this to often...

 

And then they end up with errors from each package because SCCM can´t access the server and it can´t delite the package etc (distmgr.log).

It will also stil list the DP under each package.

 

So here is how to fix that!

 

1. Backup the ConfigMgr database.

 

2. Find the entries for the DP package share:

 

Queries for finding information that needs to be delited later on.

 

Select * from pkgservers where NALpath like '%\\<servername>%' 
Select * from pkgstatus where pkgserver like '%\\<servername>%' 
Select * from contentdpmap where serverpath like '%\\<servername>%' 
Select * from DPinfo where servername like '%<servername>%'

 

 

3. Delete any entries from any of the above tables that point to the nonexistent share:

 

Queries for deliting information about the DP that was removed earlier.

 

Delete from pkgservers where NALpath like '%\\<servername>%'  
Delete from pkgstatus where pkgserver like '%\\<servername>%' 
Delete from contentdpmap where serverpath like '%\\<servername>%'  
Delete from DPinfo where servername like '%<servername>%' 

 

And you are all done..

 

Cheers!

[YiannosG]

Came in handy. Thx

[anyweb]

remember the above is not supported by Microsoft as it involves manually editing the DB

 

a supported method would be something like the below

 

http://blogs.msdn.com/rslaten/archive/2006/03/01/Removing-a-retired-DP-from-all-your-packages.aspx

 

reference > http://social.technet.microsoft.com/Forums/en-US/configmgrosd/thread/b6cd71c0-694c-491c-ad33-5ee16d5e08e4

 

cheers

niall