Wednesday, February 9, 2011

Applying MOSS 2007 Service Packs/Patches - Steps and Best practices

Well, its inevitable in a SharePoint administrator's life, Applying service packs or patches to the environment.

Here are the steps, I've learned in my implementations.

First, its a good idea to have a maintenance page for your website, in order to avoid a typical "404 - page not found" to the end users. You can design a page and host in to any QA server or any other dedicated backup servers then place a redirect in ISA Server.

Here is the simple one I've done.  Maintenance Page for SharePoint - Quick way to Implement


OK, Maintenance page is ready! Let plan for patching.

Here are the steps:
1. Download the relevant service packs for both WSS and MOSS (doesn't matter, if you have MOSS only installed. You need to have both, because MOSS runs on top of WSS) from Microsoft site, say for e.g. I've downloaded August 2010-CU for 64 bit from Microsoft site.

2. Before start installing the patches, its a good idea to remove the content db's. This will prevent your content db's from being corrupted, in case your patching fails in middle.
How to do this? execute the below stsadm commands.

stsadm -o preparetomove -contentdb <Database server:Database Name> -site <URL>

stsadm -o deletecontentdb -url <URL> -databasename <Database Name>

Remember, this is ONLY dissociate your content db's with MOSS. This will not delete your conent db's. So dont panic.

3. Once, Databases are dissociated, the next step we need to do is: stopping the world wide web publishing service on our WFE's.
to do that, in command prompt, type:  Net stop w3svc

4. Ok, Now install the WSS patch in all the servers (WFE, APP, CA), once done, you may get a prompt to restart your machine, Do that so.

5. Once rebooted, install the MOSS Patch in all the servers.

6. once completed, you have to run the "SharePoint Products and Technologies configuration wizard".
There is a sequence you need to follow in running the products and technologies configuration wizard. We need to run the configuration wizard first in the CA server, next in the App servers, and then our WFEs.
So, Start the configuration wizard in CA Server. once you get the below screen, start the cofiguration wizard in others servers as per the sequence.


Once you get the above screen in the App, Web servers, Go back to complete the wizard in CA server, then app server, and then WFEs.

Now, configuration wizard has been completed. we need to add our content db's back. once added they'll be automatically upgraded to new version..
Execute: stsadm -o addcontentdb -url <URL> -databasename <Database Name>
 
Databases are added now. you can start the W3SVC service by typing: net start S3SVC

That's All. We are done!



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

No comments :

Post a Comment

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...