 | |
SP2 on cluster mode
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#41
 
| |||
| |||
|
Re: SP2 on cluster mode -
02-21-2008
, 02:14 PM
|
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" <sean (AT) pleasenoemail (DOT) com> wrote in message news:%23DNm02KdIHA.4696 (AT) TK2MSFTNGP05 (DOT) phx.gbl... 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" <SQLCraftsman (AT) gmail (DOT) com> wrote in message news:Oo4lAaKdIHA.5900 (AT) TK2MSFTNGP02 (DOT) phx.gbl... 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" <sean (AT) pleasenoemail (DOT) com> wrote in message news:uz5vOWKdIHA.5668 (AT) TK2MSFTNGP05 (DOT) phx.gbl... 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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.