Post reply

S2k SP4

  • November 22, 2006 at 6:08 am

    #62384

    Has anyone reverted a SP4 upgrade by restoring the old Master and Msdb databases or does it require a re-install of SQL Server 2000 + SP3?

  • November 22, 2006 at 6:32 am

    #673431

    The suggested procedure described in the readme file actually contains both restoring and re-install steps.

    http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32sp4.htm

     

    -- snip from readme --

    To revert to a pre-SP4 version of SQL Server

    1. Detach all user databases. For more information, see "How to attach and detach a database (Enterprise Manager)" in SQL Server Books Online.
    2. Uninstall SQL Server. In Control Panel, double-click Add/Remove Programs, select the instance of SQL Server that you want to uninstall, and click Remove.
    3. Reinstall SQL Server 2000 from the CD-ROM or from the location where you originally installed SQL Server.
    4. Apply any service packs and hotfixes that were installed before Database Components SP4.
    5. Restore the databases master, msdb, and model from the last backup that was created before you installed. If the location of the data files has not changed, this restoration automatically attaches any user databases that were attached at the time the backup was created.
    6. Attach any user databases that were created after the last backup of the master database.
    7. Configure replication if necessary.

      -- end snip from readme --

    /Kenneth

  • November 22, 2006 at 8:30 am

    #673484

    I do not think you can revert SQL 2000 SP4. Applying a new SP does not simply apply changes in master and msdb in general. It includes many changes in objects.

    I agree with Kenneth. You need to uninstall the existing one, then, reintall SQL 2000 with SP3.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply