Service Pack install on Replicated Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Service Pack install on Replicated Server

Service Pack install on Replicated Server

Rate Topic

Display Mode

Topic Options

Author

Message

dan-572483

Posted Thursday, March 21, 2013 4:55 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 11:09 PM
Points: 328, Visits: 939

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

ksrikanth77

Posted Thursday, March 21, 2013 6:21 PM

Valued Member

Group: General Forum Members
Last Login: Friday, May 10, 2013 5:51 PM
Points: 54, Visits: 121

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 »

Permissions