Active / Active 2000 cluster.

I'm looking at MSFT press book for SQL 2005 and they say and active / active
cluster needs two virtual server names.
Can anyone confirm or deny if this is true for SQL 2000?
you also need two virtual server names (= two instances) for SQL 2000
active / active means one virtual server (instance) runs on one node, while
the other virtual server (instance) runs on the other node. Each one of
these instances are running their own set of databases.
HTH,
_Edwin.
"SQLdba" <burt_king@.yahoo.com> wrote in message
news:4AF9E22F-4C5A-4948-AE2E-E325FAD54C7C@.microsoft.com...
> I'm looking at MSFT press book for SQL 2005 and they say and active /
active
> cluster needs two virtual server names.
> Can anyone confirm or deny if this is true for SQL 2000?
|||Confirmed.
Each instance in a multi-instance cluster requires a separate virtual server
name, IP address and disk resource. This is true in SQL 2000 and 2005.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"SQLdba" <burt_king@.yahoo.com> wrote in message
news:4AF9E22F-4C5A-4948-AE2E-E325FAD54C7C@.microsoft.com...
> I'm looking at MSFT press book for SQL 2005 and they say and active /
> active
> cluster needs two virtual server names.
> Can anyone confirm or deny if this is true for SQL 2000?
|||Edwin, Geoff, thanks!!!
"Edwin vMierlo" wrote:

> you also need two virtual server names (= two instances) for SQL 2000
> active / active means one virtual server (instance) runs on one node, while
> the other virtual server (instance) runs on the other node. Each one of
> these instances are running their own set of databases.
> HTH,
> _Edwin.
>
> "SQLdba" <burt_king@.yahoo.com> wrote in message
> news:4AF9E22F-4C5A-4948-AE2E-E325FAD54C7C@.microsoft.com...
> active
>
>
|||Don't forget if one node goes down, you have 2 sql instances on 1 node.
Keep performance in mind!
Active/passive is the bomb...
I drank alot of beer and ended up in the police department database.
Drank more beer and learned SQL in the dark hours.
DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
I love SQL
"SQLdba" wrote:

> I'm looking at MSFT press book for SQL 2005 and they say and active / active
> cluster needs two virtual server names.
> Can anyone confirm or deny if this is true for SQL 2000?