Hi,

We have a SQL 2000 ent in cluster on Windows 2003 ent. on 2 nodes.
We have created an instance called Prod1 and now we want to create a second one called Prod2 on another virtual server than the first because we can't have 2 instance on 1 virtual machine.

My problem is, I have 2 disks for SQL, one is 230gig for the Databases and the other one is 230gigs for Logs.
The first intance is installed and it's using the DB disk.
When I install a new instance, I can't choose to put the Data on my DB disk, I just see the Quorum disk in the setup.

Is it normal? Can I install multiple instance and use the same disk on the storage?

thank you

PC

Each SQL Server 2000 virtual server requires its own disk resources that
CANNOT be used by other instances.

For more information, refer to the topic "Multiple-Instance Cluster" in
Microsoft SQL Server 2000 Failover Clustering Whitepaper

http://www.microsoft.com/SQL/techinf...overcluster.as
p

HTH,

Uttam Parui
SQL Server Developer Support Engineer, MCDBA, MCSE, MCT
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

XPC <anonymous (AT) discussions (DOT) microsoft.com> wrote

You can install multiple instances all of which use the same disk on
the storage if you use SQL MxDB on Polyserve Clustered file System. In
this case all the nodes in the cluster could read/write from the same
disk .

--
Tomer Meshorer
Database Engineer
Polyserve
tmeshorer (AT) polyserve (DOT) com