locked
Service Packs RRS feed

  • Question

  • I nowhere found any decsription on Service pack....

    How can we apply service packs to sql server 2000 and above?

    what the preventive measures should we take...
    manish
    Monday, February 1, 2010 5:51 PM

Answers

  • Perform backups of both system and user dbs for your SQL instance , save the configurations from sp_configure.
    Before applying it straight to the prod server , test it in your dev servers and try the fixed bugs and additional noted from the service packs explanation doc.


    Thanks, Leks
    • Marked as answer by LearnerSql Wednesday, February 3, 2010 5:53 PM
    Tuesday, February 2, 2010 8:59 AM
    Answerer
  • Hi,

    You can find several readme documents in the download page, which will introduce the service pack and point out tasks you must perform before apply this service pack. For SQL Server 2000 SP4, you can refer to the following 4 readme documents:
    ReadmeSql2k32asp4.htm, ReadmeSql2k32desksp4.htm, ReadmeSql2k32sp4.htm, ReadmeSql2k64sp4.htm.

    Hope this helps.



    Chunsong Feng
    Microsoft Online Community Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Marked as answer by LearnerSql Wednesday, February 3, 2010 5:53 PM
    Wednesday, February 3, 2010 6:31 AM
  • I have read one thread that HotFixes are very Dangerous to apply.is this true?



    Generally Service Packs are safer than Cumulative Updates and hotfixes.

    In all cases, you need to be prepared very well for the installation. Study the documentation and make a plan for rolling back the change in case operations are adversely effected. Backup all your databases prior to upgrading.


    Kalman Toth SQL SERVER 2012 & BI TRAINING
    New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012


    • Marked as answer by LekssEditor Wednesday, February 3, 2010 10:04 PM
    • Edited by Kalman Toth Thursday, October 18, 2012 10:21 PM
    Wednesday, February 3, 2010 7:40 PM

All replies

  •  

    Just download the reqd service pack for SQL 2000 from microsoft downloads and install the files.

    The latest service pack for SQL 2000 is sp4 and it can be downloaded from here

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

    If you need more info , please explain what is your exact problem with the service packs.


    Thanks, Leks
    Monday, February 1, 2010 8:06 PM
    Answerer
  • i mean to say that before applying Service Packs/ Hot fixes/ CUs/ Security Patches shld we take backups or shut down the servers / bring dBs Onlinbe/offline/backup of Tools/ Binn folders etc.


    What steps do we initiate after getting appropriate SPs/Pathes etc.


    Please help me.
    manish
    Tuesday, February 2, 2010 8:54 AM
  • Perform backups of both system and user dbs for your SQL instance , save the configurations from sp_configure.
    Before applying it straight to the prod server , test it in your dev servers and try the fixed bugs and additional noted from the service packs explanation doc.


    Thanks, Leks
    • Marked as answer by LearnerSql Wednesday, February 3, 2010 5:53 PM
    Tuesday, February 2, 2010 8:59 AM
    Answerer
  • Hi,

    You can find several readme documents in the download page, which will introduce the service pack and point out tasks you must perform before apply this service pack. For SQL Server 2000 SP4, you can refer to the following 4 readme documents:
    ReadmeSql2k32asp4.htm, ReadmeSql2k32desksp4.htm, ReadmeSql2k32sp4.htm, ReadmeSql2k64sp4.htm.

    Hope this helps.



    Chunsong Feng
    Microsoft Online Community Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Marked as answer by LearnerSql Wednesday, February 3, 2010 5:53 PM
    Wednesday, February 3, 2010 6:31 AM
  • I have read one thread that HotFixes are very Dangerous to apply.is this true?

    Is there same technique in applying Services packs/ Patcthes/hot fixes?
    manish
    Wednesday, February 3, 2010 5:52 PM
  • I have read one thread that HotFixes are very Dangerous to apply.is this true?



    Generally Service Packs are safer than Cumulative Updates and hotfixes.

    In all cases, you need to be prepared very well for the installation. Study the documentation and make a plan for rolling back the change in case operations are adversely effected. Backup all your databases prior to upgrading.


    Kalman Toth SQL SERVER 2012 & BI TRAINING
    New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012


    • Marked as answer by LekssEditor Wednesday, February 3, 2010 10:04 PM
    • Edited by Kalman Toth Thursday, October 18, 2012 10:21 PM
    Wednesday, February 3, 2010 7:40 PM