x

Behaviour of SQL Server after Windows Security patching

Hi Team,

Can any one tell what affect can hapen to SQL Active Active cluster After Windows Security patching.

Windows team are going to update the security patch on our Active Active cluster. Do i need to bring the node offline before the patching. or i can stop the service of SQL service. Do Stoping the Sql server will not affect the fail over .

Thanks

Basit khan
more ▼

asked Jun 07, 2012 at 04:43 PM in Default

basit 1 gravatar image

basit 1
499 51 61 85

(comments are locked)
10|1200 characters needed characters left

2 answers: sort oldest

You mention Active/Active cluster, by this I presume that you are running two SQL instances on a two node cluster. If this is the case here are the steps I recommend for patching Windows:

  1. Failover InstanceA to ServerB (this leaves InstanceA & InstanceB running on ServerB)
  2. In Failover Cluster Manager pause ServerA
  3. Apply Windows Patches to ServerA and reboot
  4. Unpause ServerA
  5. Failover InstanceA & InstanceB to ServerA
  6. Test to ensure that you have no problems/issues
  7. Pause ServerB
  8. Patch ServerB and reboot
  9. Unpause ServerB
  10. Failover InstanceB to ServerB
11. Done
more ▼

answered Jun 07, 2012 at 05:42 PM

SirSQL gravatar image

SirSQL
4.8k 1 3

In my Active Active cluster there are 3 instance and all are running on one node, No instance are running on the Second node. So it mean that all the instance should be failover to other node. abd then after patching on that node bring all the instance on the patched node and then i can go for patching for next node...
Jun 08, 2012 at 10:45 AM basit 1
(comments are locked)
10|1200 characters needed characters left
Personally, I'd take the node offline for patching like this. Also, I'd make sure I had a good backup in place before hand (good = tested recovery). Depending on how you stop SQL Server, it can cause a failover, so be sure you use the Cluster Manager software to stop the service if that's what you're going to do.
more ▼

answered Jun 07, 2012 at 06:04 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
101k 19 21 74

In my Active Active cluster there are 3 instance and all are running on one node, No instance are running on the Second node. So it mean that i can bring all the 3 resource offline on that node and they can go for patch that node. like let i have 3 instance 1,2, 3 on 2 node A & B 1. Failover Instance 1,2,3 on server B 2. Offline the resoucre on Server B 3. Patch the Server A, Reboot server A. 4. Failover Instance 1,2,3 on server A 5. Offline the resoucre on Server A 6. Patch Server B, Reboot Server B 7. Now after all the patching bring online all resource on Server A.

is this a correct methord. Please suggest me.
Jun 08, 2012 at 10:50 AM basit 1
(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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x162
x7

asked: Jun 07, 2012 at 04:43 PM

Seen: 1150 times

Last Updated: May 17, 2013 at 02:04 AM