SQL 2005 Active/Passive

FAQ

Profile

SQL 2005 Active/Passive

Database Forums (Home) -> Clustering

Next: Error message in the online log - CDR CDRDS

Author

Message

Steve

External

Since: Mar 14, 2006
Posts: 34

(Msg. 1) Posted: Thu Dec 20, 2007 8:48 am
Post subject: SQL 2005 Active/Passive
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

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

>> Stay informed about: SQL 2005 Active/Passive

Linchi Shea

External

Since: Mar 03, 2006
Posts: 234

(Msg. 2) Posted: Thu Dec 20, 2007 9:02 am Post subject: RE: SQL 2005 Active/Passive [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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 >> Stay informed about: SQL 2005 Active/Passive

Steve

External

Since: Mar 14, 2006
Posts: 34

(Msg. 3) Posted: Thu Dec 20, 2007 9:06 am Post subject: RE: SQL 2005 Active/Passive [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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 >> Stay informed about: SQL 2005 Active/Passive

Geoff N. Hiten

External

Since: Feb 23, 2005
Posts: 443

(Msg. 4) Posted: Thu Dec 20, 2007 12:40 pm Post subject: Re: SQL 2005 Active/Passive [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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" wrote in message > 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 >> Stay informed about: SQL 2005 Active/Passive

Steve

External

Since: Mar 14, 2006
Posts: 34

(Msg. 5) Posted: Thu Jan 03, 2008 11:11 am Post subject: Re: SQL 2005 Active/Passive [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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" wrote in message > > > 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 > > >> Stay informed about: SQL 2005 Active/Passive

Geoff N. Hiten

External

Since: Feb 23, 2005
Posts: 443

(Msg. 6) Posted: Fri Jan 04, 2008 12:24 pm Post subject: Re: SQL 2005 Active/Passive [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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" wrote in message > 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" wrote in message >> >> > 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 >> >> >> Stay informed about: SQL 2005 Active/Passive

Steve

External

Since: Mar 14, 2006
Posts: 34

(Msg. 7) Posted: Fri Jan 04, 2008 12:24 pm Post subject: Re: SQL 2005 Active/Passive [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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" wrote in message > > > 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" wrote in message > >> > >> > 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 > >> > >> > > >> Stay informed about: SQL 2005 Active/Passive

Geoff N. Hiten

External

Since: Feb 23, 2005
Posts: 443

(Msg. 8) Posted: Mon Jan 07, 2008 8:25 am Post subject: Re: SQL 2005 Active/Passive [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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" wrote in message > 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" wrote in message >> >> > 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" wrote in message >> >> >> >> > 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 >> >> >> >> >> >> >> Stay informed about: SQL 2005 Active/Passive

Steve

External

Since: Mar 14, 2006
Posts: 34

(Msg. 9) Posted: Mon Jan 07, 2008 8:25 am Post subject: Re: SQL 2005 Active/Passive [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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" wrote in message > > > 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" wrote in message > >> > >> > 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" wrote in message > >> >> > >> >> > 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 > >> >> > >> >> > >> > >> > > >> Stay informed about: SQL 2005 Active/Passive

Geoff N. Hiten

External

Since: Feb 23, 2005
Posts: 443

(Msg. 10) Posted: Mon Jan 07, 2008 10:00 am Post subject: Re: SQL 2005 Active/Passive [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

No. The SP installer is smart enough to see what is up to date. Also, you can pick which components to update if you don't want or need to update the entire list. -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "Steve" wrote in message > 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" wrote in message >> >> > 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" wrote in message >> >> >> >> > 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" wrote in message >> >> >> >> >> >> > 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 >> >> >> >> >> >> >> >> >> >> >> >> >> Stay informed about: SQL 2005 Active/Passive

Display posts from previous:

Related Topics:

what's difference between active/active and active/passive - I have a question regarding configuration of active/active and active/passive, is there any difference between them when install sql server software in windows cluster. I look at doc and can not figure out what is difference between them. Can anybody....

Active / passive in SQL 7 - A friend of mine runs QL 7 Stanad on a Compaq Cluster. I want him to upgrade to SQL 2005. I want to know how he can do the below with SQL 7? His message: That feature, available with the SQL Server7 Enterprise, would allow my passive node to startup...

Active/Active or Active/Passive - Hello, We are going to design our SQL Server databases on either Active/Active or Active/Passive of Windows 2003 clusters. Has any one seen real time risk and their real experiences of using Active/Active clusters? Thanks, John

Active/passive vs active/active? - I'd like to poll everyone out there to see what the approach is with regard to clustering, two nodes. Do you prefer active/passive or active/active, and why? TIA Michael MacGregor Database Architect

active/passive with multiple instances - Our production enviornment consists of 2 production servers in an active\passive set up. The production enviornment has 3 instances. Is it possible that a single instance can fail over to the standby node and leaving the other 2 behind? We think..

	Database Forums (Home) -> Clustering	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum