Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Service Pack install on Replicated Server Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 4:55 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 11:28 AM
Points: 553, Visits: 1,618
What is the best practice for installing a SQL Service Pack when replication is present?

The Publisher is a SQL 2008 R2 Failover Cluster. The replicated database is on a stand-alone server.

We will be installing SQL 2008 R2 SP2 on the passive node first, then failover, which will initiate the "script update" portion of the the update on the databases.

Is it necessary to turn off replication during the this process? Does the SP install on the Subscriber need to happen a close as similtaniously as possible? Will the Subscriber DB be harmed by receiving the updates twice - once by the SP install on the local server and again when the same changes are received through the replication process?

Post #1434076
Posted Thursday, March 21, 2013 6:21 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 11, 2014 2:48 PM
Points: 72, Visits: 204
Hi

Please follow the steps below

First Update the SP on the Subscriber
Apply the SP2 on the passive node
Failover and Apply SP2 on passive node
Run the update scripts on the publisher database.

Regards
Srikanth Reddy Kundur
Post #1434097
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse