Hi i need to configure 2 sql2000 server (S1 e S2) in a/a mode with two
database on the first node and other two database on the second node.

I have 3 Logical Unit SCSI on external diskarray

- q: quorum into "cluser group" with owner S1 Server

- r: dati1 into "Group 0" with owner S1 Server

- s: dati2 into "Group 1" with owner S1 Server

I now should install a SQL Virtual Server with SQL 2000 CD-ROM but how i
install virtual server for a/a mode ?

I read that i install first VS on the S1 Server and second VS on the S2
Server but how i can do it if all resource is locked is locked form S1
Server ?!?!?

How i set a datafile for VS on S1 to save to r: and datafile for VS on S2 to
save to s: if s: is locekd always from S1 server ?!?!?

Thanks in advance.

For every Active SQL you need another instance. In your case two instances
and two installs

Cheers,

Rod

<io.com> wrote

Thanks but wjat do you think about this ?

I read that i install first VS on the S1 Server and second VS on the S2
Server but how i can do it if all resource is locked is locked form S1
Server ?!?!?

How i set a datafile for VS on S1 to save to r: and datafile for VS on S2
to save to s: if s: is locekd always from S1 server ?!?!?

Thanks in advance.

You run active/active with the Microsoft shared nothing model, each
instance/node will control its own group/disk drive. If you would like to
write to one database or the other, use T-SQL.

Cheers,

Rod

<io.com> wrote

Thanks Rodney,

but a last question :

How i do configure the cluster in "shared nothing model" !??!
From Cluster Administration / Cluster administration Wizard or during a SQL
installation ?

Thanks!


"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:uHLonHtUEHA.3664 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

The shared nothing model is just the way things are. When you setup
Clustering and then SQL, both us this model.

Cheers,

Rod

<io.com> wrote