Hi all,

For performance reason, I want to devide all databases over multiple
instances.
Say 3 instances in a 4-node cluster(win2K3).Active/Active/Active/Passive

In this case, the application would need to know on which
VirtualServer/Instance the database resides.
If there is no way to tell the application, is there a solution within
SQL(2000) for it to do some kind of redirect to the rightServer/Instance
where the database does reside ?

I am looking for something similar like Exchange, where all servers in the
Organisation know where(which server) your mailbox resides.
So you could connect to any mail server and get directed to the one with
your mailbox.

Thx,

Erwin

Clustering doesn't work like that. Each instance owns a defined set of
databases. Each database can be owned by only one instance. The entire
instance fails as a unit to another host node should the first host node go
down. Clustering is not a scale-out technology.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

<Eppie> wrote

Thx,

I understand that.
I am looking for some kind of solution where you could connect to A database
without having to know which server(or instance) the database physically
resides(clustered or non-clustered).

As in the Exchange example, connecting to An Exhange server which will
redirect you to the server actually holding your mailbox.

It would be a good option for SQL to be able to do this too.

Thx,

Erwin

"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote

Hi Eppie,

You can puiblish the database to AD and let you're application search for
the database name in AD ; find the server/instance name and connect. This
solution however has nothing to do with clustering but counts for all SQL
sever installations.

The SQL server magazine had an article on this in their April number
providing explanation and code to get it working. (see link below)

http://www.winnetmag.com/Windows/Art...41/pg/1/1.html

(members only)

"Eppie" wrote: