October 26, 2011 at 12:41 pm
I am in the process of applying SS2K8R2 SP1 on some test servers and low profile live servers and I have observed different results depending on the server. So, the following are some questions I have regarding deployment.
1. In a mirror environment, should the service pack be deployed to the partner or the principle first?
2. In a replication environment, the the service pack be deployed to the subscriber or publisher first?
3. Can this be deployed on a production server without users experiencing a service outage?
Thanks.
Tom
October 26, 2011 at 4:39 pm
Okay, I notice I'm getting reads, but no replies.
Basically I already know the answer to number three, because I watched the services restart when I performed the upgrade on the test mirror environment. But the mirror partner is the only server out of the three servers I ran sp1 on that actually required a restart, which I found curious.
The reason I ask questions one and two is because I don't know if upgrading two databases (the mirror principle and the replication publisher) that will then be pushing data to what would then be a lesser version, my cause corruption. It seemed like a good question to me.
October 27, 2011 at 1:17 am
thotvedt (10/26/2011)
1. In a mirror environment, should the service pack be deployed to the partner or the principle first?
I've never patched a mirrored server but the same process applies as did in SQL 2005 and the detail is found on the link below
http://support.microsoft.com/kb/926824
thotvedt (10/26/2011)
2. In a replication environment, the the service pack be deployed to the subscriber or publisher first?
There are a few references for this but the order it should be applied is distributor, publisher and subscriber. Obviously, you may have a publisher/distributor which shortens the sequence.
I hope this helps. 😀
November 3, 2011 at 11:57 am
Thanks. Yes it does help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply