Never got a response back so, I thought I’d share how I removed the Duplicate
Distribution Points from our SCCM 2012 R2 environment.. I had a total of 4
duplicates out of over 166 branch DP’s.
To get a quick tally of total count of Dup’s and the ID’s you may have you can
quickly run:
Select ID,
Count (*) TotalCount
From
V_DistributionPointInfoBase
Group By Id
Having Count (*) >1
Order by Count (*) Desc
Removing Duplicate Distribution Points from SCCM 2012/SQL DB
Confirm duplicate exist in SQL DB by running query in SQL Management Studio
against SCCM
select * from sc_address Order by DestinationSiteCode
Search for your Server Name, if duplicate exist, you will see 2 rows for that
server.
Then proceed to do the following if Duplicate exists:
**NOTE** No need to remove content from DP if it already exist. **
1) Remove “Distribution Point” Role from Branch Server that’s showing a
Duplicate under “Administration > Servers & Site Systems Roles”
2) Remove “Site System” Role the same as noted in step 1.
3) Run Primary Site Back up at this step. Remote onto Primary and
manually start “SMS_Site_Bkup” Service
4) Pull up and monitor Bkup log on Primary. SMSdbMon.log. and wait till it
completes.. Last line in log will say services stopped.
Now from SQL Studio run :
delete from sc_address where destinationsitecode like '%SERVERNAME%'
Recheck that duplicate rows are now gone by re-running the original select
statement but just check for the Servername only.. it should be gone:
select * from sc_address where DestinationSiteCode like '%SERVERNAME%'
Once confirmed Duplicate is gone, Re-add DP site Role in SCCM console.. Wait 10
minutes before adding DP Group association back..
DONE !
Dwayne Hebert. MCTS. MCP. A+
SCCM ADMINISTRATOR
Systems Infrastructure
IB Color_blue jpg
--- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com
<<image001.jpg>>
