how to apply sp2 on active/active node in sql 2008

Question

how to apply sp2 on active/active node in sql 2008

hydbadrose

SSCarpal Tunnel

Points: 4164
More actions
November 18, 2010 at 8:07 pm

#243064

I have a question about applying a service pack2 on active/active node. we have clustA and clustB servers and each node has named and default instance installed so how many sp2 I need to install on each server and how?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

You will need to install SP2 on each node. When installing, you can select which instances to apply it to - you would normally select all. (I just went through this on a cluster with three instances.)

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

hydbadrose SSCarpal Tunnel Points: 4164 More actions · Answer 2

Do you have any document or site that you could provide? Thanks

WayneS SSC Guru Points: 95460 More actions · Answer 3

Have you tried the documents related to installing the SP on MicroSoft's site? What have you tried?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

hydbadrose SSCarpal Tunnel Points: 4164 More actions · Answer 4

I checked on google, microsoft site , many other sites and I got the really good documents but I am not getting the clear picture of how you choose the instance.

WayneS SSC Guru Points: 95460 More actions · Answer 5

During the install of the SP, you will have a screen showing all of the installed instances, with check boxes beside them, as well as the common components. The common components check box is checked and dimmed - they will be installed. You can select any or all of the instances to upgrade.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

hydbadrose SSCarpal Tunnel Points: 4164 More actions · Answer 6

hydbadrose

SSCarpal Tunnel

Points: 4164

November 19, 2010 at 1:04 pm

#1253279

Thanks