Showing posts with label cluster. Show all posts
Showing posts with label cluster. Show all posts

Sunday, March 11, 2012

Cumulative update package2 for SQL2005 SP2 - cluster aware?

Hi,
Is the "Cumulative update package2 for SQL2005 SP2"
(http://support.microsoft.com/kb/936305) cluster aware? Or do it need to be
installed on each cluster node?
Thanks!
SQL_help
Hi
You need to install service pack on SQL Instance (NODE1) and binaries get
copied to the second(passive) node.
If you have ACTIVE/ACTIVE configuration then you need to install an both
sql instances
"SQL_help" <aaa@.bbb.com> wrote in message
news:eNn5ZPr1HHA.1336@.TK2MSFTNGP04.phx.gbl...
> Hi,
> Is the "Cumulative update package2 for SQL2005 SP2"
> (http://support.microsoft.com/kb/936305) cluster aware? Or do it need to
> be installed on each cluster node?
> Thanks!
> SQL_help
>

Cumulative update

I am getting ready to install a new cluster and was wondering what the best
cumulative update would be. I am installing it on a HP 460c blade server and
using the x64 version of SQL2005 Enterprise.
Any help is appreciated.
Start with SP2. Then depending on what problems you are running into apply
the latest hot fixes. They are all cumulative.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dave B" <DaveB@.discussions.microsoft.com> wrote in message
news:655E5E3C-8ED2-44D3-838F-87D2DC1BFCDF@.microsoft.com...
>I am getting ready to install a new cluster and was wondering what the best
> cumulative update would be. I am installing it on a HP 460c blade server
> and
> using the x64 version of SQL2005 Enterprise.
> Any help is appreciated.
>
|||I have been running build 3161 (Post SP2 hotfix) with no problems so far.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Dave B" <DaveB@.discussions.microsoft.com> wrote in message
news:655E5E3C-8ED2-44D3-838F-87D2DC1BFCDF@.microsoft.com...
>I am getting ready to install a new cluster and was wondering what the best
> cumulative update would be. I am installing it on a HP 460c blade server
> and
> using the x64 version of SQL2005 Enterprise.
> Any help is appreciated.
>

Thursday, March 8, 2012

Cumulative Hotfix Package - Build 2153

I'm getting ready to install the Cumulative Hotfix Package - Build 2153 on a 2-node, Active/Passive cluster (MSSQL 2005 EE on Windows 2003). I've read through the docs a number of times but don't see any reference to clustering. Should I apply the hotfixes to each node or are the fixes cluster-aware?

Thanks.I also have a 2-node Active/Passive cluster (MSSQL 2005 64-bit on Windows 2003). I would like to apply the cumulative hotfix, but I too have not found any documentation specific to a clustered installation. Did you install the hotfix on your cluster? If yes, did you have any issues?

Cumulative Hotfix Package - Build 2153

I'm getting ready to install the Cumulative Hotfix Package - Build 2153 on a 2-node, Active/Passive cluster (MSSQL 2005 EE on Windows 2003). I've read through the docs a number of times but don't see any reference to clustering. Should I apply the hotfixes to each node or are the fixes cluster-aware?

Thanks.
I also have a 2-node Active/Passive cluster (MSSQL 2005 64-bit on Windows 2003). I would like to apply the cumulative hotfix, but I too have not found any documentation specific to a clustered installation. Did you install the hotfix on your cluster? If yes, did you have any issues?