SQL Server Performance

SQL2000 SP4 release date?

Discussion in 'General DBA Questions' started by jeremy, Feb 17, 2005.

  1. jeremy New Member

    Anyone heard anything on SQL2000 SP4 release. We have the Beta and are wondering if anyone knows when they will release the real version.
  2. Luis Martin Moderator

    Microsoft said: soon.

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  3. Moonwalker2000 New Member

    "and SP4 scheduled release date is H2 of 2005 (barring any regression). "

    From my TAM
  4. satya Moderator

    .. and if you're interested you can particpate in Beta programme.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. joettu New Member

    Talked to a tech today and they said that it was due to be released on the 29th of April, but there were some hangups but it literally could be released any day...
  6. Luis Martin Moderator

    Good news, then.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  7. derrickleggett New Member

    Yep, today would be today. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br /<a target="_blank" href=http://www.microsoft.com/sql/downloads/2000/sp4.asp>http://www.microsoft.com/sql/downloads/2000/sp4.asp</a><br /><br />MeanOldDBA<br />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.
  8. ranjitjain New Member

    Would it be good to install sp4 or its better to wait this service pack to get settled as i think its beta version.
    Plz let me know ur comments before i install it on my integrated server.
  9. derrickleggett New Member

    It's not beta anymore. This is the official release. My plan is:

    1. Wait a month.
    --Come up with a test plan based on fix list.
    --Monitor forums and tech news for problems.
    2. Test on dev for a couple weeks.
    3. Test on QA, UAT, RELEASE for a week.
    4. Move to production a week later.

    I wouldn't be hasty about moving this directly onto a production system.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  10. Luis Martin Moderator

    Tha't new for me.
    I mean Derrick plan for SP4.
    Same plan with others sp or just for this one?




    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  11. derrickleggett New Member

    I've used that on all the service packs. It saved my job on a couple of the old ones (6.5 and 7.0). I just think it's good to be diligent and make sure you've tested a release like this really well.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  12. Argyle New Member

    Woha, you have dev, qa, uat and release environments. Your a lucky guy [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]
  13. tamsun New Member

    http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5

    SP4 includes packages for the following SQL Server 2000 components:
    Database Components (Download file: SQL2000-KB884525-SP4-x86.EXE)
    Update your 32-bit Database components of SQL Server 2000 including Database Engine, Replication, Client Connectivity components and Tools. For additional information, please refer to ReadmeSql2k32Sp4.htm


    Analysis Services Components (Download file: SQL2000.AS-KB884525-SP4-x86.EXE):
    Update your 32-bit Analysis Services components of SQL Server 2000. For additional information, please refer to ReadmeSql2k32ASp4.htm.


    SQL Server 2000 Desktop Engine (MSDE) Components (Download file: SQL2000.MSDE-KB884525-SP4-x86.EXE):
    For your 32-bit MSDE components of SQL Server 2000:
    Install a new instance of MSDE
    Upgrade existing instances of MSDE
    Update applications that have consumed merge modules
    For additional information, please refer to ReadmeSql2k32DeskSp4.htm


    SQL Server 2000 64-bit Components (Download file: SQL2000-KB884525-SP4-ia64.EXE):
    Update your 64-bit Database components and 64-bit Analysis Services components of SQL Server 2000. For additional information, please refer to ReadmeSql2k64Sp4.htm



  14. derrickleggett New Member

    ?

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  15. ranjitjain New Member

    Thanx Derrick,[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />As its official release then, ill test it on my development server for couple of<br />weeks as suggested by you.<br />Plz post ur experts comments if u get any problems after installing.[:0]<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by derrickleggett</i><br /><br />It's not beta anymore. This is the official release. My plan is:<br />1. Wait a month.<br />--Come up with a test plan based on fix list.<br />--Monitor forums and tech news for problems.<br />2. Test on dev for a couple weeks.<br />3. Test on QA, UAT, RELEASE for a week.<br />4. Move to production a week later.<br />I wouldn't be hasty about moving this directly onto a production system.<br />MeanOldDBA<br />derrickleggett@hotmail.com<br />When life gives you a lemon, fire the DBA.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
  16. derrickleggett New Member

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] I'll let everyone know how it goes. I'm hoping all the testing and waiting on other people to "iron it out" will prevent any of them from hitting production.<br /><br />MeanOldDBA<br />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.
  17. satya Moderator

  18. fhanlon New Member

    I tried to install SP4 on a test machine that has 3 instances. As per the instruction I stopped the instance I was upgrading because I wanted to try to avoid a machine restart. (From the Readme "You can reduce the likelihood that you will need to restart your computer after you install Database Components SP4. To reduce this likelihood, stop the services and applications in the preceding list before you run Setup." I installed SP4 but I still had to do a restart. Perhaps this is because I did not stop the other instances? Anyway the restart is not necessarily easy to avoid. I will leave SP4 on the test machine for a few weeks before attempting another server

  19. satya Moderator

    If it confirms about restart of services then you must follow to avoid any unnecessary errors in future. I don't see any issues in restarting services as you're playing on the test environment.

    WE've followed as suggested without any issues.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page