 | |
SQL 2005 Active/Passive
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#51
 
| |||
| |||
|
Re: SQL 2005 Active/Passive -
01-07-2008
, 09:00 AM
|
the service pack was installed when the sql2005 was installed on the active (and passive). if i install the workstation tools, should i install it on the passive again..and will that cause any issues? thanks. steve "Geoff N. Hiten" wrote: It is safest to run the installer when the node is not currently hosting anything, but it is not mandatory. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:39C10FAB-0230-4748-B13F-1927D44AAD07 (AT) microsoft (DOT) com... Thanks Geoff..I am more of an Exchange admin than a SQL admin. should I fail back to the other node before doing this on the passive (currently the active node)? "Geoff N. Hiten" wrote: Run the installer. When you get to the components selection screen, run "Workstation Components". Then re-run the service pack. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:E3641033-B621-414D-8FFA-DD68B9B6E0A6 (AT) microsoft (DOT) com... Do you have a link to the instructions..and should it be failed over to the other node when doing this? Thanks. Steve "Geoff N. Hiten" wrote: You can do a workstation components only install on the "other" node. The tools installation component is not cluster-aware. There is no problem with adding the tools to additional cluster nodes. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:7AD7D09F-90CA-413F-B4B8-17C67827704C (AT) microsoft (DOT) com... Thanks--so we need to fail it back to the active to get the full performance tools, etc.? "Linchi Shea" wrote: That's by design. Linchi "Steve" wrote: We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
#52
| |||
| |||
|
|
the service pack was installed when the sql2005 was installed on the active (and passive). if i install the workstation tools, should i install it on the passive again..and will that cause any issues? thanks. steve "Geoff N. Hiten" wrote: It is safest to run the installer when the node is not currently hosting anything, but it is not mandatory. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:39C10FAB-0230-4748-B13F-1927D44AAD07 (AT) microsoft (DOT) com... Thanks Geoff..I am more of an Exchange admin than a SQL admin. should I fail back to the other node before doing this on the passive (currently the active node)? "Geoff N. Hiten" wrote: Run the installer. When you get to the components selection screen, run "Workstation Components". Then re-run the service pack. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:E3641033-B621-414D-8FFA-DD68B9B6E0A6 (AT) microsoft (DOT) com... Do you have a link to the instructions..and should it be failed over to the other node when doing this? Thanks. Steve "Geoff N. Hiten" wrote: You can do a workstation components only install on the "other" node. The tools installation component is not cluster-aware. There is no problem with adding the tools to additional cluster nodes. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:7AD7D09F-90CA-413F-B4B8-17C67827704C (AT) microsoft (DOT) com... Thanks--so we need to fail it back to the active to get the full performance tools, etc.? "Linchi Shea" wrote: That's by design. Linchi "Steve" wrote: We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
#53
| |||
| |||
|
|
the service pack was installed when the sql2005 was installed on the active (and passive). if i install the workstation tools, should i install it on the passive again..and will that cause any issues? thanks. steve "Geoff N. Hiten" wrote: It is safest to run the installer when the node is not currently hosting anything, but it is not mandatory. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:39C10FAB-0230-4748-B13F-1927D44AAD07 (AT) microsoft (DOT) com... Thanks Geoff..I am more of an Exchange admin than a SQL admin. should I fail back to the other node before doing this on the passive (currently the active node)? "Geoff N. Hiten" wrote: Run the installer. When you get to the components selection screen, run "Workstation Components". Then re-run the service pack. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:E3641033-B621-414D-8FFA-DD68B9B6E0A6 (AT) microsoft (DOT) com... Do you have a link to the instructions..and should it be failed over to the other node when doing this? Thanks. Steve "Geoff N. Hiten" wrote: You can do a workstation components only install on the "other" node. The tools installation component is not cluster-aware. There is no problem with adding the tools to additional cluster nodes. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:7AD7D09F-90CA-413F-B4B8-17C67827704C (AT) microsoft (DOT) com... Thanks--so we need to fail it back to the active to get the full performance tools, etc.? "Linchi Shea" wrote: That's by design. Linchi "Steve" wrote: We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
#54
| |||
| |||
|
|
the service pack was installed when the sql2005 was installed on the active (and passive). if i install the workstation tools, should i install it on the passive again..and will that cause any issues? thanks. steve "Geoff N. Hiten" wrote: It is safest to run the installer when the node is not currently hosting anything, but it is not mandatory. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:39C10FAB-0230-4748-B13F-1927D44AAD07 (AT) microsoft (DOT) com... Thanks Geoff..I am more of an Exchange admin than a SQL admin. should I fail back to the other node before doing this on the passive (currently the active node)? "Geoff N. Hiten" wrote: Run the installer. When you get to the components selection screen, run "Workstation Components". Then re-run the service pack. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:E3641033-B621-414D-8FFA-DD68B9B6E0A6 (AT) microsoft (DOT) com... Do you have a link to the instructions..and should it be failed over to the other node when doing this? Thanks. Steve "Geoff N. Hiten" wrote: You can do a workstation components only install on the "other" node. The tools installation component is not cluster-aware. There is no problem with adding the tools to additional cluster nodes. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:7AD7D09F-90CA-413F-B4B8-17C67827704C (AT) microsoft (DOT) com... Thanks--so we need to fail it back to the active to get the full performance tools, etc.? "Linchi Shea" wrote: That's by design. Linchi "Steve" wrote: We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
#55
| |||
| |||
|
|
the service pack was installed when the sql2005 was installed on the active (and passive). if i install the workstation tools, should i install it on the passive again..and will that cause any issues? thanks. steve "Geoff N. Hiten" wrote: It is safest to run the installer when the node is not currently hosting anything, but it is not mandatory. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:39C10FAB-0230-4748-B13F-1927D44AAD07 (AT) microsoft (DOT) com... Thanks Geoff..I am more of an Exchange admin than a SQL admin. should I fail back to the other node before doing this on the passive (currently the active node)? "Geoff N. Hiten" wrote: Run the installer. When you get to the components selection screen, run "Workstation Components". Then re-run the service pack. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:E3641033-B621-414D-8FFA-DD68B9B6E0A6 (AT) microsoft (DOT) com... Do you have a link to the instructions..and should it be failed over to the other node when doing this? Thanks. Steve "Geoff N. Hiten" wrote: You can do a workstation components only install on the "other" node. The tools installation component is not cluster-aware. There is no problem with adding the tools to additional cluster nodes. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote in message news:7AD7D09F-90CA-413F-B4B8-17C67827704C (AT) microsoft (DOT) com... Thanks--so we need to fail it back to the active to get the full performance tools, etc.? "Linchi Shea" wrote: That's by design. Linchi "Steve" wrote: We have a sql2005 active/passive win2003 x64 cluster. when the db's are on the active node..we see all of the sql tools available. on the passive node, we don't. is this by design as we did a complete install. any help is appreciated. thx. steve |
|
« 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.