Grab our RSS feeds Follow us on Twitter Join our Facebook Group Connect with us on LinkedIn
myITforum.com, Powered by You.
you are not logged in

Articles

Newslinks

Links

Downloads

Site Services

Community Forums

Discussion Lists

Article Search

Newsletter

Web Blogs

FAQs

Live Support

myITforum TV

Take a Poll

Monthly Drawing

myITforum Network

User Group Directory

Our Partners

About Us

Register

Login

BRONZE PARTNER:

BRONZE PARTNER:



Industry News:




  Home : Articles : SMS 2.x print | email | | Forums |   print | email | | Blogs |   print | email | | Wiki |   print | email | | FAQs |   print | email | Article Search  
Removing Old Site Systems from the SMS Database


Bookmark and Share

By: Ed Aldrich
Posted On: 6/25/2001


  1. Open SQL Enterprise Manager
  2. Open the SMS Database and then go to Tables
  3. Select the Table: "Summarizer_SiteSystem"
  4. Right click on the table and select
    Open Table-Return All Rows
  5. Place a -1 in the Replicate Column for all instances of the specific Servers that no longer exist.

This will effectively remove the server from the Site Systems Status messages in about 30 minutes.

You can also 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 the servers that are no longer defined as component servers (that is, not set in the MMC Site Settings/Site Systems as a CAP or DP). Eventually you will then have access to the DELETE function when accessing the entry under Site Settings/Site Systems in the SMS Admin console.

Extra Note: If you are simply wanting to change the status from critical to OK then change the status column for that site system from 2 to 0.

  myITforum.com ©2010 | Legal | Privacy