You and your consultant have your terminology crossed.
You want a multi-instance cluster in a 2x2 configuration. (2 instances on 2
nodes). The active and passive terminology refers to a specific SQL 7.0
clustering technology that is no longer relevant or even possible.
IMHO, if you and your consultant are butting heads over definitions, you
might want to rethink this relationship. I have lived on both sides of the
table and expect better either way.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
[quoted text, click to view] "andyz" <andyz@discussions.microsoft.com> wrote in message
news:65D588CF-D6E4-4ED5-AB17-875642C5BDFE@microsoft.com...
>I have a consultant telling me that there is no such thing as an
> active/active sql cluster. I want to install 2 seperate instances on 2
> seperate sql 2005 servers in a cluster.
>
> The consultant is telling me that this is active passive because only 1
> instance is active at a time on 1 server. I do not beleive this to be
> correct
> but I am no database expert. Can someone please give me some clsrity
> here..
>
>
> Thanks alot
A rose by any other name.....
You're correct active/active is two nodes, each with it's own instance.
Nothing is shared in this configuration... That means the data partitions
and the data on them....
--
databaseadmins.com
Remote DBA Services
[quoted text, click to view] "Geoff N. Hiten" wrote:
> You and your consultant have your terminology crossed.
>
> You want a multi-instance cluster in a 2x2 configuration. (2 instances on 2
> nodes). The active and passive terminology refers to a specific SQL 7.0
> clustering technology that is no longer relevant or even possible.
>
> IMHO, if you and your consultant are butting heads over definitions, you
> might want to rethink this relationship. I have lived on both sides of the
> table and expect better either way.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "andyz" <andyz@discussions.microsoft.com> wrote in message
> news:65D588CF-D6E4-4ED5-AB17-875642C5BDFE@microsoft.com...
> >I have a consultant telling me that there is no such thing as an
> > active/active sql cluster. I want to install 2 seperate instances on 2
> > seperate sql 2005 servers in a cluster.
> >
> > The consultant is telling me that this is active passive because only 1
> > instance is active at a time on 1 server. I do not beleive this to be
> > correct
> > but I am no database expert. Can someone please give me some clsrity
> > here..
> >
> >
> > Thanks alot
>
Don't see what you're looking for? Try a search.