RE: Removing a DP

Hi Terry,

Thank you for posting!

>From your message, I understand that you need to remove a DP.

Based on my experience, you may refer to the following steps to remove it
manually.

1 Open every package that used these Distribution Points, then delete
these Distribution Points from the list. To do that,

SMS Admin Console -> Packages -> Distribution Points -> highlight -> Right
click -> Delete.

2. Delete these Distribution Points from SQL Database.

Open SQL Enterprise Manager. -> Select SMS Server -> SMS Database -> Tables
-> locate SysReslist -> right click -> Open Table -> Return all rows -> If
you see these server names under ServerName column, it should be deleted.

3. To delete them, use SQL Query Analyzer. Consult with SQL expert to
create a SQL query. Basically, you have to use "Delete" TSQL statement.

4. Stop and start SMS_Executive.

Also, you may refer to the following steps.

1. Go into SQL Enterprise Manager and open the SMS Database
2. Go to Tables and select the Table "Summarizer_SiteSystem"
3. Right click and select Open Table-Return All Rows
4. Place a "-1" (without the quotes) in the Replicate Column for all
instances of DP Servers that no longer exist.
5. Go to Tables and select the Table "sysreslist" delete all references to
the component server that is no longer valid.
6. On the site server access and delete old Site Component Servers still
found in the registry of the SMS site server under:
HKLM/Software/Microsoft/SMS/Components/SMS_SITE_COMPONENT_MANAGER/Component
Servers

Delete those servers no longer defined as component servers (that is, not
set in the MMC Site Settings/Site Systems as a DP).

7. Then open the SMS admin console and DELETE the entry under Site
Settings/Site Systems.

Hope this helps! If you have further concern, feel free to let me know.
Have a great day!

Sincerely,
Jack Wang, MCSE 2000/2003, MCSA 2000/2003, MCDBA, MCSD
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:

BCPS:https://partner.microsoft.com/US/technicalsupport/supportoverview/40010
469
Others:https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
======================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: "Terry Matthews" <nospam@xxxxxxxxxxx>
| Subject: Removing a DP
| Date: Tue, 8 Nov 2005 17:43:39 -0700
| Lines: 15
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <OsfKaaM5FHA.1140@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.sms.admin
| NNTP-Posting-Host: 208.4.182.60
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sms.admin:68317
| X-Tomcat-NG: microsoft.public.sms.admin
|
| So three hours ago I went to a site system and removed the checkbox to be
a
| distribution point.
|
| However nothing is happening??
|
| There is no throttling or sender restrictions... it is on a high speed
| connection.
|
| Does anyone know how I can speed things up here? I have tried starting
and
| stopping services, but not sure what else?
|
| Thanks,
| Terry
|
|
|

.

Relevant Pages

  • RE: Changing IP adressing on Win 2003 servers.
    ... This is Morgan from Microsoft and will be ... For non-SBS servers and this Windows Server 2003 is running the critical ... All computers' IP address should be changed correctly. ... Microsoft Advisory Services is a remotely-delivered, consultative support ...
    (microsoft.public.windows.server.setup)
  • RE: Can I access 100GB on eight different servers with single share na
    ... Distributed File System: ... Microsoft Customer Support Services via telephone so that a dedicated ... Microsoft Online Partner Support ... Can I access 100GB on eight different servers with single share na ...
    (microsoft.public.windows.file_system)
  • Re: ID 7011 from Srvc Cntrl Mgr during logon/offs
    ... Microsoft Support professionals. ... Microsoft CSS Online Newsgroup Support ... and the servers re-drawing of the desktop ...
    (microsoft.public.windows.server.sbs)
  • Re: Can CPUs differ in a cluster?
    ... I would state that your current cluster would likely NOT be supported if ... the Windows Catalog using different vendor's servers. ... processor speed as it should already be violating support agreements. ... Microsoft will bless it. ...
    (microsoft.public.windows.server.clustering)
  • RE: SQL2005 to SQL2000
    ... The database backed up in SQL 2005 cannot be restored on SQL 2000 Server. ... the database detached from 2005 cannot be attched to 2000 servers. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.access.adp.sqlserver)