SQL 2005sp2+ Replication 3 server environment..

Last Post 16 Sep 2008 10:32 AM by ufohj. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
mcdye
New Member
New Member

--
28 Jul 2008 05:07 AM
We have a 3 server environment (PubServer(PS), DistServer(DS), SubServer(SS)). We are using push Transactional Replication. The PS is EntEd Cluster 32bit sp2.3177, the DS is StdEd 64 bit sp2.3186 and the SS is EntEd Cluster 64 bit sp2.3186. We are looking at applying Cumualtive Update#8 to all but not at the same time. I know the DS has to be higher or equal to the PS and what I have read the SS doesnt matter since of the Replication method we are using.

1) We will apply the CU#8 to the DS first, is there anything I need to stop before applying?
2) We will apply the CU#8 to the SS next, is there anything I need to stop before applying?
3) At some point later we apply CU#8 to the PS, I gather there is nothing to stop here?

4) On the same lines what about applying Windows Updates and reboots to each of the servers? Should anything be stopped on any of them?

TIA!
mcdye
New Member
New Member

--
28 Jul 2008 10:25 AM
thanks for the reply, I am conerned about the stop/starts that occur applying a hotfix.
ufohj
New Member
New Member

--
16 Sep 2008 10:32 AM
The correct order should be:

DS-->PS-->SS
You are not authorized to post a reply.

Acceptable Use Policy