<div>
I always use the SharePoint Team Blog for this sort of information - <a href="http://blogs.msdn.com/sharepoint/archive/2009/04/28/announcing-service-pack-2-for-office-sharepoint-server-2007-and-windows-sharepoint-services-3-0.aspx" rel="ugc">http://blogs.msdn.com/sharepoint/archive/2009/04/28/announcing-service-pack-2-for-office-sharepoint-server-2007-and-windows-sharepoint-services-3-0.aspx</a><br />
<br />
Note that SP2 is actually pretty old, so you should probably install the latest cumulative updates. Nott sure whats the latest.<br />
<br />
Yes you will need to install SP2 on all servers. 
</div>


I always use the SharePoint Team Blog for this sort of information - http://blogs.msdn.com/sharepoint/archive/2009/04/28/announcing-service-pack-2-for-office-sharepoint-server-2007-and-windows-sharepoint-services-3-0.aspx [http://blogs.msdn.com/sharepoint/archive/2009/04/28/announcing-service-pack-2-for-office-sharepoint-server-2007-and-windows-sharepoint-services-3-0.aspx]

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.

<div>
I mean do I need to do anything on SQL server during upgrade.
</div>


I mean do I need to do anything on SQL server during upgrade.

<div>
No, &nbsp;the Configuration Wizard will actually touch the Config database and make the appropriate changes. You will not need to do anything extra.
</div>


No,  the Configuration Wizard will actually touch the Config database and make the appropriate changes. You will not need to do anything extra.

<div>
Do I need to restart all the servers after upgrade?
</div>


Do I need to restart all the servers after upgrade?

<div>
<div class="content wysiwyg-content">
how to upgrade from moss sp1 to sp2 in a farm enviroment.<br />
1 application server<br />
1 index server<br />
2 web front end server<br />
<br />
Do I need to upgarde each server, if yes then how to do it like which server should I upgrade first
</div>
</div>


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

moss upgrade sp1 to sp2

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.