Changing cluster configuration

My current cluster configuration is Active/Passive, I'm exploring a change to
Active/Active, but I haven't been able to find any informaon on how to do
this, has anyone ever done this? My reason for considering this is the size
of the current server, and the need to bringup other applications on the
seconday node.
Active/Passive and Active/Active are old terms. What you want to build is a
multi-instance cluster. You simply install a new instance of SQL server
with its own disk(s), IP address, and network name. After the installation
you can configure each instance to have preferred owner nodes under normal
conditions.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jerrick D.H" <JerrickDH@.discussions.microsoft.com> wrote in message
news:1EB1CFF5-CACD-41A2-B9ED-06F02A766BC8@.microsoft.com...
> My current cluster configuration is Active/Passive, I'm exploring a change
to
> Active/Active, but I haven't been able to find any informaon on how to do
> this, has anyone ever done this? My reason for considering this is the
size
> of the current server, and the need to bringup other applications on the
> seconday node.
|||Jerrick,
Geoff's answer is dead on!
The only other thing to consider is that there can only be ONE default
instance PER CLUSTER.
The second instance you install will likely be a NAMED INSTANCE.
The virtual server name you choose for your second instance MUST BE UNIQUE,
and the instance name will of course need to be unique as well.
Here are some good resources:
http://www.microsoft.com/technet/pro.../failclus.mspx
and in BOL -
Multiple Instances of SQL Server
Failover Clustering Example - This is very good and I think speaks to your
question perfectly as well.
Hope that helps!
Donna Lambert
Microsoft PSS
SQL Server Support

Change node names and move cluster to new domain

I have an active/passive SQL 2005 cluster consisting of 2 nodes. My bosses
want me to rename both nodes and also move the cluster to a new domain. How
would I do that ?.
Regards
Tony Dawson
There is no easy way to do this.
http://support.microsoft.com/kb/915846/en-us
will get you through the domain change. To change the node names, you will
have to evict, change, and readd each node.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Tony Dawson" <noone@.nowhere.org> wrote in message
news:0E3AECC8-4C34-4BD5-BE89-71D34D023A11@.microsoft.com...
>I have an active/passive SQL 2005 cluster consisting of 2 nodes. My bosses
>want me to rename both nodes and also move the cluster to a new domain. How
>would I do that ?.
> Regards
> Tony Dawson
|||You might want to ask yourself if the reasons for doing this are strong
enough to outweigh the risk and efford of this excercise.
Are there any technical reasons why you want to do this ?
Oh, and take a backup... and test the backup before you begin.
But sure that goes for every maintenance you do.
rgds,
Edwin.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23yjCbRkIIHA.5208@.TK2MSFTNGP04.phx.gbl...
> There is no easy way to do this.
> http://support.microsoft.com/kb/915846/en-us
> will get you through the domain change. To change the node names, you
will[vbcol=seagreen]
> have to evict, change, and readd each node.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Tony Dawson" <noone@.nowhere.org> wrote in message
> news:0E3AECC8-4C34-4BD5-BE89-71D34D023A11@.microsoft.com...
bosses[vbcol=seagreen]
How
>
|||Geoff, that KB article handles the domain *group* change but not changing
the domain. I don't think you can move a cluster to another domain.
As for renaming nodes, the only way to do that is to:
1) evict one node
2) rename the node
3) bring the node back into the cluster
4) re-apply the binaries to the node
5) repeat for all nodes
This is all a major PITA. I think there has to be very compelling reason to
change domains or rename nodes within a server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23yjCbRkIIHA.5208@.TK2MSFTNGP04.phx.gbl...
There is no easy way to do this.
http://support.microsoft.com/kb/915846/en-us
will get you through the domain change. To change the node names, you will
have to evict, change, and readd each node.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Tony Dawson" <noone@.nowhere.org> wrote in message
news:0E3AECC8-4C34-4BD5-BE89-71D34D023A11@.microsoft.com...
>I have an active/passive SQL 2005 cluster consisting of 2 nodes. My bosses
>want me to rename both nodes and also move the cluster to a new domain. How
>would I do that ?.
> Regards
> Tony Dawson