SP2 on cluster mode

Geoff

Thanks for the reply. Just to understand better, I just need to run the SQL
2005 SP2 on current host node
and after update, I run it again on the 2nd node, right? Also can I do the
same thing with Windows 2003 SP2?

Thanks

"Geoff N. Hiten" wrote in message

> You will need to install SP2 starting from the current host node to update
> the engine and agent. You will need to run SP2 from each node in order to
> update SSIS and the client tools, just like you had to run the installer
> on each node to install SSIS and client tools.
>
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
>
>
> "Sean" wrote in message
>
>> I've got a 2-node SQL Server 2005 running. There is no sql service packs
>> installed and Windows 2003 service packs. the sql-cluster was built
>> while back. Is there a special way to install SQL SP2? Do I just install
>> the SP2 on each node?
>>
>> Thanks in advance
>>
>
 >> Stay informed about: SP2 on cluster mode 

Windows is stand alone, so you'll need to do the SP on both.

with SQL, because the DB Engine is shared between the nodes, when you
install the SQL SP it dumps the updated files on all of your nodes.
But because there are parts that are not part of the cluster (such as ssis,
client tools etc) you need to run the SP on all nodes to update those none
clustered parts...

if all you have is the DB Engine then you only need to run the SP on the
active node.



"Sean" wrote in message

> Geoff
>
> Thanks for the reply. Just to understand better, I just need to run the
> SQL 2005 SP2 on current host node
> and after update, I run it again on the 2nd node, right? Also can I do
> the same thing with Windows 2003 SP2?
>
> Thanks
>
> "Geoff N. Hiten" wrote in message
>
>> You will need to install SP2 starting from the current host node to
>> update the engine and agent. You will need to run SP2 from each node in
>> order to update SSIS and the client tools, just like you had to run the
>> installer on each node to install SSIS and client tools.
>>
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>>
>>
>>
>> "Sean" wrote in message
>>
>>> I've got a 2-node SQL Server 2005 running. There is no sql service packs
>>> installed and Windows 2003 service packs. the sql-cluster was built
>>> while back. Is there a special way to install SQL SP2? Do I just
>>> install the SP2 on each node?
>>>
>>> Thanks in advance
>>>
>>
>
 >> Stay informed about: SP2 on cluster mode 

Yep.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Justin Rich" wrote in message

> Windows is stand alone, so you'll need to do the SP on both.
>
> with SQL, because the DB Engine is shared between the nodes, when you
> install the SQL SP it dumps the updated files on all of your nodes.
> But because there are parts that are not part of the cluster (such as
> ssis, client tools etc) you need to run the SP on all nodes to update
> those none clustered parts...
>
> if all you have is the DB Engine then you only need to run the SP on the
> active node.
>
>
>
> "Sean" wrote in message
>
>> Geoff
>>
>> Thanks for the reply. Just to understand better, I just need to run the
>> SQL 2005 SP2 on current host node
>> and after update, I run it again on the 2nd node, right? Also can I do
>> the same thing with Windows 2003 SP2?
>>
>> Thanks
>>
>> "Geoff N. Hiten" wrote in message
>>
>>> You will need to install SP2 starting from the current host node to
>>> update the engine and agent. You will need to run SP2 from each node in
>>> order to update SSIS and the client tools, just like you had to run the
>>> installer on each node to install SSIS and client tools.
>>>
>>> --
>>> Geoff N. Hiten
>>> Senior SQL Infrastructure Consultant
>>> Microsoft SQL Server MVP
>>>
>>>
>>>
>>>
>>> "Sean" wrote in message
>>>
>>>> I've got a 2-node SQL Server 2005 running. There is no sql service
>>>> packs installed and Windows 2003 service packs. the sql-cluster was
>>>> built
>>>> while back. Is there a special way to install SQL SP2? Do I just
>>>> install the SP2 on each node?
>>>>
>>>> Thanks in advance
>>>>
>>>
>>
>
>
 >> Stay informed about: SP2 on cluster mode