November 22, 2016 at 7:57 am
Hi
We have to upgrade a 2008 server to 2012. This server is a subscriber for transactional replication. The publisher is a 2012 server and is our main server. MS articles suggest that publisher activity needs to be stopped before upgrade of subscriber. BUt since the publisher is our main business server, we can't afford to stop activity on that. Has someone upgraded a replicated subscriber server without interfering with publisher?
Will it suffice if I just stop the log reader agent, upgrade the subscriber and then start the log reader agent?
thanks
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
November 24, 2016 at 3:44 am
HI,
Yes we did upgrade subscribers before and we did not stop activity on publisher. Either u can stop logreader or distribution agent before doing an upgrade on subscriber.
BartL
Replication Blog
November 28, 2016 at 7:39 am
Just in case if it helps anyone, we did the upgrade of subscriber by stopping the Distributor agent for all publishers and it worked just fine. Stopping log reader agent is not suggested by many experts as it will blow out your log file.
thanks
SKS
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply