applying sql 2008 sp2 for cluster

Last Post 19 Nov 2012 04:50 PM by rm. 11 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
ctseah
New Member
New Member

--
16 Dec 2011 01:35 AM
Hi,

I am preparing to apply SQL 2008 sp2 in cluster environment.

Node A is active node, SQL 2008 started on Node A.
Node B is passive node.

May I know whether I can proceed using this sequence ?
1) shutdown Node B.
2) leaving Node A being active node, apply SP2 on Node A.
3) shutdown A.
4) startup Node B, SQL 2008 started on Node B, apply SP2 on Node B.
5) shutdown Node B.
6) startup Node A, SQL 2008 started on Node A.
7) startup Node B

Thank you in advance for your input/ advise.

Regards
rm
New Member
New Member

--
16 Dec 2011 06:01 AM
Don't have to shutdown passive node. If OS is win2k8 or win2k8 r2, you can :
1. install sql2k8 sp on passive node B and reboot it.
2. failover sql to node B.
3. install sql2k8 sp on node A and reboot it.
4. failover sql to node A to ensure works on both nodes.

Why don't install sql2k8 sp3 instead?
ctseah
New Member
New Member

--
18 Dec 2011 01:17 AM

Hi,

Thanks.
Thought the latest is sql 2008 sp2. Will check it up.

Regards

ctseah
New Member
New Member

--
10 Jan 2012 07:31 PM
Hi,

Will apply the latest sql 2008 sp3.

By the way is it easy to roll back the service pack once it is applied ?

The earlier versions of sql has no way to roll back other than uninstall and reinstall the whole sql binary and then followed by restoration of the databases.

Can the roll back be made through add/remove programs ?

regards
rm
New Member
New Member

--
11 Jan 2012 07:01 AM
Yes, you can uninstall sp and cu on sql2k8.
ctseah
New Member
New Member

--
14 Nov 2012 05:25 AM
Hi,

I applied the sp2 on passive node as advised.
However I could not successfully failover the sql server to the passive node.

The sp2 was applied on passive node successfully without any error, but not sure why I can't fail over successfully to complete the whole process.

I am at a loss at how to resolve this.

Where do you think might have gone wrong ?

thanks in advance.
rm
New Member
New Member

--
14 Nov 2012 05:38 AM
Did you get any error when tried to failover?
ctseah
New Member
New Member

--
14 Nov 2012 07:08 AM
Hi,

No specific error as far as I can see.
But somehow the quorum drive did not failover to the node that I have just applied the sp2.
Thus the sql related services are not able to start.

But if I revert everything back to the original sp1, and tried the failover process, I could failover without any issue to and fro.
Once I applied the sp2 on the passive node and try to failover, it does not work. Quroum drive not failing over as it should.

Thanks in advance.

regards
ctseah
New Member
New Member

--
15 Nov 2012 02:45 AM
Hi,

Any idea which window login account I should use to apply this sp2 ?

Regards
rm
New Member
New Member

--
15 Nov 2012 05:52 AM
I never had that on my clusters. Failover sql instance doesn't require failover quroum unless you have them in same resource group which is not good setup in first place. Anyway, there should be some error in windows event logs and cluster log.
ctseah
New Member
New Member

--
18 Nov 2012 11:33 PM
Hi,

I realised that I was using the domain account which has administrative rights in O/S but does not have sysadmin rights in the sql server when executing the sql sp2 installation.

Do I need to execute the sp2 installation using an domain account which have both administrative rights in O/S and also a sysadmin in sql server ?

Could this be the reason why I could not fail over successfully ?

Thanks
Regards
rm
New Member
New Member

--
19 Nov 2012 04:50 PM
Yes, need sysadmin rights to install sql sp.


Acceptable Use Policy
---