moss upgrade sp1 to sp2

how to upgrade from moss sp1 to sp2 in a farm enviroment.
1 application server
1 index server
2 web front end server

Do I need to upgarde each server, if yes then how to do it like which server should I upgrade first
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I always use the SharePoint Team Blog for this sort of information -

Note that SP2 is actually pretty old, so you should probably install the latest cumulative updates. Nott sure whats the latest.

Yes you will need to install SP2 on all servers.
You will need to first install WSS 3.0 SP2 on all servers in the farm and then install MOSS SP2 on all servers in the farm.

Execute the WSS 3.0 SP2 upgrade on all servers, in any order. When the install is complete, it will prompt you to run the "SharePoint Configuration Wizard". Cancel it on all servers (including the web front end- you will run this after you install the MOSS SP2.

Essentially you're installing the application on the servers and then running the configuration wizard (where the actual database/configuration changes take place).  Once you install the MOSS SP2, It will again prompt you to run the configuration wizard. Start the Wizard on the web front end first, it will then stop before the actual upgrade begins and instruct you to install it on the other servers in your farm first, and then come back to the front end. After the install runs and completes, revisit your web front end and complete the install. The whole process shouldn't take too long. I remember the MOSS SP2 installation taking a little longer than the WSS SP2 install. The configuration wizard runs fairly quick as well.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dkumeriAuthor Commented:
anything on SQL server?
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

dkumeriAuthor Commented:
I mean do I need to do anything on SQL server during upgrade.
No,  the Configuration Wizard will actually touch the Config database and make the appropriate changes. You will not need to do anything extra.
dkumeriAuthor Commented:
Do I need to restart all the servers after upgrade?
dkumeriAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.