Active / Active 2000 cluster. -- sql server clustering

SQLdba
3/22/2007 8:20:37 AM

Edwin, Geoff, thanks!!!

[quoted text, click to view]

Geoff N. Hiten
3/22/2007 11:07:57 AM

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

[quoted text, click to view]

Edwin vMierlo
3/22/2007 3:02:09 PM

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.

[quoted text, click to view]

Hate_orphaned_users
3/23/2007 1:26:56 PM

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 :)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : Active / Active 2000 cluster.