Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Service Pack install on Replicated Server


Service Pack install on Replicated Server

Author
Message
dan-572483
dan-572483
SSChasing Mays
SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)

Group: General Forum Members
Points: 649 Visits: 1958
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?
ksrikanth77
ksrikanth77
SSC Journeyman
SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)

Group: General Forum Members
Points: 77 Visits: 249
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search