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?