Re: SQL 2000 extra instance into same group
- From: "Anthony Thomas" <ALThomas@xxxxxxxxx>
- Date: Mon, 5 Mar 2007 08:43:00 -0600
There is a trace flag that will disable the disk dependency check, but why
would you do that?
The whole point of a failover cluster to provide multiple hardware
components to support a virtual interface. These items are placed in a
resource group such that if any one of them fails, the whole group fails,
and is then picked up and presented on an active member node.
If you had multiple instances running in the same resource group, not only
would they have to share the same disk, but the same IP address and network
name as well. If one were to fail, then they all would fail. You want to
limit your failure points to just a single instance, but affect all
resources required to maintain that instance.
Keep this in mind: when a failure occurs, there is still a service outage.
It is just automatically detected and recovered, but it is still an outage
(much shorter than on a single host) but an outage nevertheless. Why would
you want the availability of one instance to be affected by another? If
that is acceptable, consolidate, don't multi-instance. Host all of your
databases on the same instance. This way, they all fail together, but in a
supported configuration.
Sincerely,
Anthony Thomas
--
"Jason" <Jason@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EF7AB703-E241-4FCD-A587-FCD9FD7B0171@xxxxxxxxxxxxxxxx
I understand the requirements just would like to know if there is a waythe
around it.
I don't see why you cant have multiple instances using the same disk.
Regards
Jason
"Edwin vMierlo" wrote:
Jason,
Every instance requires its own group/disk/IP/networkname in a cluster.
rgds,
Edwin.
"Jason" <Jason@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:449F2FFA-5E23-4DE7-94C0-DA0236CAC163@xxxxxxxxxxxxxxxx
I would like to add 2 instances of SQL 2000 into one Disk group within
andcluster
IE
I have InstanceOne utilisng setup in cluster group using a drive (O:\)
thewould like to install InstanceTwo into the same cluster group using
same
drive (0:\)
When you go through the installation O drive is not visible.
Is there a way around this supported or otherwise?
Thanks & Regards
Jason
.
- Follow-Ups:
- Re: SQL 2000 extra instance into same group
- From: Edwin vMierlo
- Re: SQL 2000 extra instance into same group
- Prev by Date: Re: how many number of nodes
- Next by Date: Re: Connecting to cluster instance from .NET
- Previous by thread: Re: SQL 2000 extra instance into same group
- Next by thread: Re: SQL 2000 extra instance into same group
- Index(es):
Relevant Pages
|
