How to apply SQL Server 2005 service pack 4

  • Hi everyone

    As a newbie I am looking for some kind of Readme file with step by step instructions on how to instal SQL Server 2005 service pack 4. Official site does not have any . Will appreciate any help.

    Thank you

    p.s we have single instance with a few databases (OS -Windows NT, Platform -X86)

  • evevea (4/19/2012)


    Hi everyone

    As a newbie I am looking for some kind of Readme file with step by step instructions on how to instal SQL Server 2005 service pack 4. Official site does not have any . Will appreciate any help.

    Thank you

    p.s we have single instance with a few databases (OS -Windows NT, Platform -X86)

    It is just an exe.

    From the MS download page (http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7218)

    Instructions

    Note: You must have administrative rights on the computer to install SQL Server 2005 SP4.

    Step 1: Download and review the Setup documentation and readme file.

    For known issues, review the Release notes.

    Step 2: Download the appropriate package by clicking one of the links below.

    o To start the installation immediately, click Run.

    o To install SP4 at a later time, click Save.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Thank you very much. I have seen that page but was expecting a bit more than just "How to obtain ...." and How to install SQL server itself.

    For example, do I need to take databases offline prior to installation or what services need to be shut running and etc.

  • evevea (4/20/2012)


    Thank you very much. I have seen that page but was expecting a bit more than just "How to obtain ...." and How to install SQL server itself.

    For example, do I need to take databases offline prior to installation or what services need to be shut running and etc.

    Just run the exe it takes care o everything for you, you will require a reboot

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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