DOCUMENT:Q171338  27-JUL-2001  [sms]
TITLE   :SMS: Preparing for a Systems Management Server Upgrade
PRODUCT :Microsoft Systems Management Server
PROD/VER:winnt:1.1,1.2
OPER/SYS:
KEYWORDS:kbnetwork kbsetup smssetup smshowto

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Systems Management Server versions 1.1, 1.2 
-------------------------------------------------------------------------------


SUMMARY
=======

Upgrading a site that is not in a functioning, healthy state may cause serious
problems, and may require a reinstallation. This article outlines recommended
procedures for upgrading a Systems Management Server site from version 1.1 to
1.2 or for applying a service pack. Following these procedures should prevent
problems from occurring.

MORE INFORMATION
================

The following steps should be performed before all Systems Management Server
upgrades (including the application of service packs) are performed:

1. Read the Readme.txt files, release notes, and all .txt files that accompany
   the service pack or the upgrade CD.

2. Read chapter 8, "Upgrading," of the Systems Management Server 1.2
   Installation and Configuration Guide.

3. Ensure that the Systems Management Server service account is working, has
   Domain Admin, Domain Users, Administrator, and the Logon As A Service
   advanced user rights in all domains participating in the site.

4. Check the Windows NT Application Event log (on the parent site and any
   children) for connectivity or hierarchy related errors.

5. Back up the following:

    - The Systems Management Server registry key and subkeys found in
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\

   -and-

    - The site control file ...\Sms\Site.srv\Sitecfg.box\Sitectrl.ct0.

   -and-

    - The ...Sms\System.map on the primary site and child secondary sites (if
      any exist).

6. Back up the site with a full database dump and directory backup.

7. Use Network Monitor to check the network usage and bandwidth, and do the
   upgrade during non-busy hours.

8. VERY IMPORTANT: Perform a site reset at every primary site (from within
   Systems Management Server Setup) and stop and restart the Site Configuration
   Manager service on the all child Secondary sites (if any).

9. Ensure that SQL Server is configured properly. For more information on SQL
   Server configuration, refer to the following article in the Microsoft
   Knowledge Base:

   Q166244 SMS: SQL Server Tuning Parameters for Systems Management Server

10. Ensure that the transaction log and the Systems Management Server database
   is not full. If necessary, increase the log size, database size, tempdb, or
   device size before upgrading.

If there are child secondary sites, also do the following:

1. Ensure connectivity from the parent to the child and visa versa with Net
   View, and so on.

2. Check that ALL secondary sites are active by looking at the status screen in
   the site properties in the Systems Management Server Administrator program.
   The Hman.log file should show all sites active (status 1). This is very
   important because if one secondary site is not active, the upgrade will be
   delayed or may fail.

Additional Notes
----------------

 - Systems Management Server 1.2 Service Pack 2 introduced a switch to delay the
   automatic upgrade of child secondary sites. For more information, please
   refer to the service pack's Readme.txt file.

 - For more information on secondary site installation and upgrades, visit the
   following Web site:

   http://www.microsoft.com/smsmgmt/

   When you are on the Web site, click "Deployment & Support" and then click
   "Technical Papers".

 - It may be necessary to reinstall the SQL Server service pack after applying
   the Systems Management Server service pack. Systems Management Server 1.2
   Service Pack 2 overwrites some SQL Server service pack files.

Additional query words: prodsms SP1 SP2 SP

======================================================================
Keywords          : kbnetwork kbsetup smssetup smshowto 
Technology        : kbSMSSearch kbSMS110 kbSMS120
Version           : winnt:1.1,1.2
Issue type        : kbhowto kbinfo

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 2001.