Clustering patch issue

Hello All,

Consider Applying patches in sql server clustering Nodes,

First i have tried to apply the patches in Passive Node(Node B), It got updated successfully. After that i have tried to Applied in Passive Node A(Fail over Clustering setup to Node B). We received some unknown error. Finally we decided we could not updated the Patch in Node A. That time what kind of action we need to take resolved the issue?

Note :- This question has been asked in SQL DBA interview. I never faced this situation, So i couldn't answer for this question.
more ▼

asked Apr 21 at 12:13 PM in Default

Mohamed4053 gravatar image

201 2 13 18

Yes i found some solution, we can remove the service pack from the server which is updated successfully.
Apr 25 at 09:30 AM Mohamed4053
This site works by voting. Please indicate all helpful answers by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate this by clicking on the check mark next to that answer.
Apr 27 at 01:20 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
This is the type of question you'll get on an interview after we get through the basic questions. It's meant to be open ended without a single firm answer. The interviewer is looking to see how you would address the issue. What kind of questions would you ask in terms of the status of the situation and the servers involved. The answer should be a give and take conversation that shows your troubleshooting skills as well as your knowledge (maybe you have hit exactly this issue). Personally, I don't know what the answer is for certain, but I'd have a whole conversation I could around the issue to show how I'd go about troubleshooting it and the issues involved, where I might go for further information, logs or counters I might check, etc. It has to be YOUR answer, showing your knowledge, not a canned answer from the internet.
more ▼

answered Apr 21 at 06:23 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

You are right.. I never had much chance to work with this kind of Issues. Still i am preparing answer for this question. Meanwhile i concluded, we have to remove patch from other server which we installed successfully.
Apr 22 at 07:55 AM Mohamed4053
(comments are locked)
10|1200 characters needed characters left
Refer to this Microsoft support article on applying patches for fail over cluster nodes. http://support.microsoft.com/kb/958734 . Hope this helps.
more ▼

answered Apr 22 at 03:59 AM

Venkataraman gravatar image

1k 1 3

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 21 at 12:13 PM

Seen: 291 times

Last Updated: Apr 27 at 01:20 PM