Hi, On primary location, we have SQL Server 2005 EE x64 with SP3 in server A and MOSS 2007 with SP1 in Server B. On Seondary location, for DR, we have SQL Server 2005 EE x64 with SP3 in server C and MOSS 2007 with SP1 in Server D. Configuring log log shipping: Deleted the content databases on Server D and then took the backup for the content databases on server A, copied to server D and restored with NORECOVERY & then configured the log shipping for the content databases and everything is running fine. Now we want to apply SP2 for MOSS 2007 on Server B (On primary) and on Server D (On Secondary) Question: In order to apply the MOSS 2007 SP2 on Primary as well as on Secondary, what are the stetps we need to follow? please advice

The same as in every SharePoint Farm, starting with the CA, then APPs, then WFEs.. There are two parts to upgrade the Software or Bits and the Schema changes via running the SharePoint Products and Technologies Configuration Wizard...Since your environment consists of 2 SharePoint servers.. Download and Install the Bits for WSS and MOSS.. Install WSS SP2 first then MOSS SP2, this can be done at the same time on both servers.. Do not run the PSConfiGUI > SharePoint Products and Technologies Configuration Wizard until you have installed the Bits on All SharePoint Servers and only run the PSConfiGUI on one server at a time, wait until it finishes with the one before starting the nextIn other words run the PSConfiGUI on the local server, when it completes run PSConfiGUI on the remote server. Cheers,-Ivan Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.

Just to add, there is a nice article on technet regarding the configuration of Log Shipping for Disaster Recovery purposes:http://technet.microsoft.com/en-us/library/dd890507.aspxHope this helps, Koen Vosters http://koenvosters.wordpress.com