Post reply

Applying SP4 to SQL 2000

  • April 21, 2006 at 7:32 am

    #169056

    Good morning.  I'm fairly new to SQL administration and I've never applied a service pack before.  However, the task has fallen to me.  Can anyone give any guidelines or steps to iterate when applying SP4 to MS SQL 2000?  Thanks.

    Chris

  • April 21, 2006 at 2:32 pm

    #633622

    there is really nothing to it; you download the service pack , open it and it is a couple of NEXT>> buttons;

    it will stop the server automatically,(so don't do it during a time it will affect users), install itself and then cause a reboot in order to start itself with the new settings.

    you'll want to back up every database (including master and msdb) before doing this just in case there is an issue; i've done this on dozens of machines with no problems so far...

    hope that helps.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 25, 2006 at 1:36 pm

    #634154

    Thanks, Lowell.

  • September 27, 2006 at 9:23 am

    #662762

    Lowell (or anyone that has the answers), just a few more questions, please.  Any special considerations for a log-shipping infrastructure?  Should I install it on the primary or secondary server, first?  Do I need to disable log-shipping first?  Etc.?  Thanks.

    Chris

  • October 6, 2006 at 7:37 am

    #664593

    Nevermind everyone.  I found a post on another site.  The crux of the post (on the other site) was that if you applied the SP to the primary first, then you would have to failover and then apply it to the secondary.  So, we applied it to the secondary first and then to the primary.  There were no problems during our installation (log-shipping went down for a few minutes, but was restored automatically once both servers were at the same SP level).  Thanks.

    Chris

Viewing 5 posts - 1 through 4 (of 4 total)

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