Jamie's Blog

1. Backup the database.

2. Find the entries for the DP package share:

Select * from pkgservers where NALpath like ‘%\\Server%’
Select * from pkgstatus where pkgserver like ‘%\\Server%’
Select * from contentdpmap where serverpath like ‘%\\Server%’
Select * from DPinfo where servername like ‘%Server%’
3. Delete any entries from any of the above tables that point to the nonexistent share:

Delete from pkgservers where NALpath like ‘%COMPUTERNAME’ 
Delete from pkgstatus where pkgserver like ‘%Server%’
Delete from contentdpmap where serverpath like ‘%Server%’ 
Delete from DPinfo where servername like ‘%Server%’

Tags: SCCM, SQL