Does this means.. if we have 2 instances on active/passive cluster... we can
make it active/active by just moving one instance on the other node. Thats
it.. correct? Thanks in advance for your reply.
"Geoff N. Hiten" wrote:
> Tom is trying very hard to answer your question.
> You have a Single-instance, two-node cluster. The 'Active/Passive'
> nomenclature went away with SQL 7.0 when clustering setup and functionality
> changed drastically. You can add more instances to your cluster. Each
> Instance will act as an independent SQL Server. You cannot have two host
> nodes "share" a set of databases and scale out that way.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:B69A7772-DC00-40B9-AFEA-7354393ADEAA@.microsoft.com...
>
"DBA05" <DBA05@.discussions.microsoft.com> wrote in message
news:43794BBE-EDA5-4F67-AAD4-8BFF835071C1@.microsoft.com...
> Does this means.. if we have 2 instances on active/passive cluster... we
> can
> make it active/active by just moving one instance on the other node. Thats
> it.. correct? Thanks in advance for your reply.
Yes.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
Dec 10 - 13 in Denver
Jan 18 - 31 in Denver
|||Is it possible to change name of SQL Server Instance on Cluster? If yes, what
is the appropriate way to do it?
Thanks.
"Russ Kaufmann [MVP]" wrote:
> "DBA05" <DBA05@.discussions.microsoft.com> wrote in message
> news:43794BBE-EDA5-4F67-AAD4-8BFF835071C1@.microsoft.com...
> Yes.
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
> The next ClusterHelp classes are:
> Dec 10 - 13 in Denver
> Jan 18 - 31 in Denver
>
|||You cannot rename an instance if it is clustered:
http://support.microsoft.com/kb/260414
(See question 5.) You would have to reinstall.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"DBA05" <DBA05@.discussions.microsoft.com> wrote in message
news:57FBF475-5224-4FA7-A217-DC94147C63D5@.microsoft.com...
Is it possible to change name of SQL Server Instance on Cluster? If yes,
what
is the appropriate way to do it?
Thanks.
"Russ Kaufmann [MVP]" wrote:
> "DBA05" <DBA05@.discussions.microsoft.com> wrote in message
> news:43794BBE-EDA5-4F67-AAD4-8BFF835071C1@.microsoft.com...
> Yes.
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
> The next ClusterHelp classes are:
> Dec 10 - 13 in Denver
> Jan 18 - 31 in Denver
>
Showing posts with label moving. Show all posts
Showing posts with label moving. Show all posts
Thursday, March 22, 2012
Friday, February 24, 2012
Accessing Virtual Server Names
Hello,
We are moving from a 2 node, Acitive-Passive cluster to a 4 node cluster; 3
Active 1 passive.
We have 3 Virtual Servers. We have defaulted one virtual server per active
node.
I want to be able to run a different version of our software on each virtual
server; thus three folders one for each for the install. I would like to
update the path variable to point to a different folder based on the virtual
server name.
Can't seem to find out how to get the name of the virtual server the user
logged into.
Or, am I taking the completely wrong approach?
Thanks for any help.
Evan R.
You seem to have your terms and definitions mixed up.
Active-Active-Passive-etc nomenclature is misleading and does not reflect
how clustering in SQL 2000 works.
First, instances are not associated with particular nodes as was the case in
SQL 7.0. The only exception is certain tasks (Service packs, hotfixes, disk
changes) must be done from the node currently hosting the virtual server.
You can have sixteen instances per cluster, regardless of the number of host
nodes in the cluster. SQL 2000 supports up to 4 nodes per cluster. You can
have only one default instance per cluster. I suggest using only named
instances on a cluster for consistancy. Since each instance appears as a
separate server on the network, a query of the @.@.servername global variable
will easily distinguish which server a user is connected to.
Geoff N. Hiten
Microsoft SQL Server MVP
"BeenThereGotLost" <BeenThereGotLost@.discussions.microsoft.com> wrote in
message news:54DDC256-9949-421F-8240-82C54A882B1C@.microsoft.com...
> Hello,
> We are moving from a 2 node, Acitive-Passive cluster to a 4 node cluster;
> 3
> Active 1 passive.
> We have 3 Virtual Servers. We have defaulted one virtual server per active
> node.
> I want to be able to run a different version of our software on each
> virtual
> server; thus three folders one for each for the install. I would like to
> update the path variable to point to a different folder based on the
> virtual
> server name.
> Can't seem to find out how to get the name of the virtual server the user
> logged into.
> Or, am I taking the completely wrong approach?
> Thanks for any help.
> Evan R.
|||Thanks Geoff. Hopefully this will clear up my question.
We stage equipment & databases for our customers. The customer's database
replicates to a database on a named SQL instance running on a virtual server
in the cluster.
To stage the equipment our manufacturing folks have to log into the virtual
server and run some command line utilities. The utilities build the
replication, accounts, etc. I would like to modify the path in the
environment based on the name of the virtual server. This would allow me to
have different versions of the software for different virtual servers. I am
constraining the problem by putting only one instance of SQL on each virtual
server.
From a cmd shell, I need the name of the virtual server the manufacturing
person has logged into. I'm willing to use command line utility, Script, or
API to access the virtual server name.
"Geoff N. Hiten" wrote:
> You seem to have your terms and definitions mixed up.
> Active-Active-Passive-etc nomenclature is misleading and does not reflect
> how clustering in SQL 2000 works.
> First, instances are not associated with particular nodes as was the case in
> SQL 7.0. The only exception is certain tasks (Service packs, hotfixes, disk
> changes) must be done from the node currently hosting the virtual server.
> You can have sixteen instances per cluster, regardless of the number of host
> nodes in the cluster. SQL 2000 supports up to 4 nodes per cluster. You can
> have only one default instance per cluster. I suggest using only named
> instances on a cluster for consistancy. Since each instance appears as a
> separate server on the network, a query of the @.@.servername global variable
> will easily distinguish which server a user is connected to.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "BeenThereGotLost" <BeenThereGotLost@.discussions.microsoft.com> wrote in
> message news:54DDC256-9949-421F-8240-82C54A882B1C@.microsoft.com...
>
>
We are moving from a 2 node, Acitive-Passive cluster to a 4 node cluster; 3
Active 1 passive.
We have 3 Virtual Servers. We have defaulted one virtual server per active
node.
I want to be able to run a different version of our software on each virtual
server; thus three folders one for each for the install. I would like to
update the path variable to point to a different folder based on the virtual
server name.
Can't seem to find out how to get the name of the virtual server the user
logged into.
Or, am I taking the completely wrong approach?
Thanks for any help.
Evan R.
You seem to have your terms and definitions mixed up.
Active-Active-Passive-etc nomenclature is misleading and does not reflect
how clustering in SQL 2000 works.
First, instances are not associated with particular nodes as was the case in
SQL 7.0. The only exception is certain tasks (Service packs, hotfixes, disk
changes) must be done from the node currently hosting the virtual server.
You can have sixteen instances per cluster, regardless of the number of host
nodes in the cluster. SQL 2000 supports up to 4 nodes per cluster. You can
have only one default instance per cluster. I suggest using only named
instances on a cluster for consistancy. Since each instance appears as a
separate server on the network, a query of the @.@.servername global variable
will easily distinguish which server a user is connected to.
Geoff N. Hiten
Microsoft SQL Server MVP
"BeenThereGotLost" <BeenThereGotLost@.discussions.microsoft.com> wrote in
message news:54DDC256-9949-421F-8240-82C54A882B1C@.microsoft.com...
> Hello,
> We are moving from a 2 node, Acitive-Passive cluster to a 4 node cluster;
> 3
> Active 1 passive.
> We have 3 Virtual Servers. We have defaulted one virtual server per active
> node.
> I want to be able to run a different version of our software on each
> virtual
> server; thus three folders one for each for the install. I would like to
> update the path variable to point to a different folder based on the
> virtual
> server name.
> Can't seem to find out how to get the name of the virtual server the user
> logged into.
> Or, am I taking the completely wrong approach?
> Thanks for any help.
> Evan R.
|||Thanks Geoff. Hopefully this will clear up my question.
We stage equipment & databases for our customers. The customer's database
replicates to a database on a named SQL instance running on a virtual server
in the cluster.
To stage the equipment our manufacturing folks have to log into the virtual
server and run some command line utilities. The utilities build the
replication, accounts, etc. I would like to modify the path in the
environment based on the name of the virtual server. This would allow me to
have different versions of the software for different virtual servers. I am
constraining the problem by putting only one instance of SQL on each virtual
server.
From a cmd shell, I need the name of the virtual server the manufacturing
person has logged into. I'm willing to use command line utility, Script, or
API to access the virtual server name.
"Geoff N. Hiten" wrote:
> You seem to have your terms and definitions mixed up.
> Active-Active-Passive-etc nomenclature is misleading and does not reflect
> how clustering in SQL 2000 works.
> First, instances are not associated with particular nodes as was the case in
> SQL 7.0. The only exception is certain tasks (Service packs, hotfixes, disk
> changes) must be done from the node currently hosting the virtual server.
> You can have sixteen instances per cluster, regardless of the number of host
> nodes in the cluster. SQL 2000 supports up to 4 nodes per cluster. You can
> have only one default instance per cluster. I suggest using only named
> instances on a cluster for consistancy. Since each instance appears as a
> separate server on the network, a query of the @.@.servername global variable
> will easily distinguish which server a user is connected to.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "BeenThereGotLost" <BeenThereGotLost@.discussions.microsoft.com> wrote in
> message news:54DDC256-9949-421F-8240-82C54A882B1C@.microsoft.com...
>
>
Subscribe to:
Posts (Atom)