Solved

How do I fix mismatch SP2+Hotfix to SQL Cluster Node

Posted on 2009-07-13
9
441 Views
Last Modified: 2012-05-07
Background: I have an Active-Passive Cluster environment hosting 24x7 critical hospital databases. I noticed that SP2+patch is missing on Passive node and planning to apply missing sp2+patch on Passive Node. This is a PRODUCTION and Critical so want to verify all my steps well in advance.

                                               VIRTUAL
--------- Node-1------------            --------- Node-2------------

Windows 2003 Enterprise SP2       Windows 2003 Enterrpise SP2
SQL 2005 Enterprise, SP2+Patch   SQL 2005 Enterprise, SP1
Active                                                              Passive

PLAN-A
1) Full Backups of all databases (System and Users).
2) Move groups on Node-2 using Cluster Administrator
3) Pause Node-1 using Cluster Administrator
4) Apply SP2 on Node-2.  SP2 is cluster aware and this will search for Passive (Node-1 now) but it is in PAUSED so will complete only on NODE-2.
5) Continue for Patch in the same manner on Node-2.
6) Check Version on Node-2.
7) Resume-Node Node-1 using Cluster Administrator
8) Move groups on Node-1 using Cluster Administrator

PLAN-B
1) Full Backups of all databases (System and Users).
2) Move groups on Node-2 using Cluster Administrator
3) Apply SP2 on Node-2.  SP2 is cluster aware and this will search for Passive (Node-1) and it is already up to date and will do nothing but will apply sp2 only on NODE-2.
4) Continue for Patch in the same manner on Node-2.
5) Check Version on Node-2.
6) Move groups on Node-1 using Cluster Administrator
7) Test results.

PLAN-C
1) Full Backups of all databases (System and Users).
2) Go to Node-1 (Active) and apply SP3. SP3 is cluster aware and will complete on Passive first and then active.
3) Check version on Active-Node-1.
4) Move groups on Node-2 using Cluster Administrator
5) Check version on Node-2 Active now.
6) I can remove SP3 only in add/remove program any time if anything goes wrong.

Questions:
1) Can I remove sp2 or patch only from Node-2 if anything goes wrong using add/remove program? I think this is not ROLLOVER as in SQL 2008.
2) Which plan is 100%?
3) Please add expert comments only.

Thank you very much in advance for everyone.
0
Comment
Question by:SSHARMA2
  • 6
  • 3
9 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24842772
SP on sql cluster should be applied while being connected on the cluster instance.
patching a individual node should not work?

unless you only patched a client tools?

>I noticed that SP2+patch is missing on Passive node
can you clarify how you identified that?
0
 

Author Comment

by:SSHARMA2
ID: 24842963
Hi - Genius
I tested in the following way
a) I ran the following query when I was connected to Node-1 ( It gave me SP2+Patch info);
SELECT SERVERPROPERTY('productversion') AS VersionNumber,
       SERVERPROPERTY ('productlevel') AS ProductLevel,
       SERVERPROPERTY ('edition') AS Edition

b) Failover on Node-2 and ran same query and got SP1 info.
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 24843099
apart from that "problem", you might consider getting to SP3:
http://support.microsoft.com/kb/934749

that article also shows the "how to" apply the patches.
0
 

Author Comment

by:SSHARMA2
ID: 24843528
Hi - angellll,
Thanks for your prompt reply.

I know SP3 is perfect solution but considering overall situation I will concentrate on Workaround 'Method 1' (http://support.microsoft.com/kb/934749): Sounds like my PLAN-B.
 
a) Fail over to the new node.
b) Pause other nodes by using Cluster Administrator.
c) Install SQL Server 2005 SP2 on the new node.
d) Apply SQL Server 2005 SP2 Cumulative Update 6 and the appropriate hotfixes as applicable to the scenario on the new node.
e) Start the nodes that you paused
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24843562
yes, except that you planned to play safe with:
1) Full Backups of all databases (System and Users).
which is really good!
0
 

Author Comment

by:SSHARMA2
ID: 24928385
We have next week schedule to complete this task and I will post my comments after that. Thanks.
0
 

Author Comment

by:SSHARMA2
ID: 25025295
This has been rescheduled and will take place after three weeks.
0
 

Author Comment

by:SSHARMA2
ID: 25225389
This has been completed successfully. Thanks for suggestion and verification.
0
 

Author Closing Comment

by:SSHARMA2
ID: 31602961
This was nice experience that we can ask/verify solution before apply on PROD.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Rebuild index results in duplicate key violation 9 42
SQL Where not exists in same table 3 53
SQL Date from a string 4 58
execute a MS SQL script as a schedule SQL job 72 125
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now