March 21, 2013 at 4:55 pm
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?
March 21, 2013 at 6:21 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply