Re: active/passive with multiple instances

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Yes...you are correct...but to date I have not heard anyone outside of
academia and Microsoft fora use
multi-instance. When they say Active/Active, we all know what they mean :-)

Sorry to have pushed your terminology button Mike :-)

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm



"Michael Hotek" <mike@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ueVAb99EGHA.648@xxxxxxxxxxxxxxxxxxxxxxx
> No, thus leaving your cluster as a multi-instance cluster. There is
> absolutely, no such thing as an active/active or active/passive SQL Server
> cluster. Such a thing does not exist at all.
>
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
>
> "Kevin3NF" <Kevin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:eV5VIU9EGHA.1464@xxxxxxxxxxxxxxxxxxxxxxx
>> Thus turning your cluster into active/active :-D
>>
>> --
>> Kevin Hill
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>>
>>
>>
>> "Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
>> news:O9cbhWzBGHA.3528@xxxxxxxxxxxxxxxxxxxxxxx
>>> Nope. Each instance has its own resource dependency list. If a
>>> resource that is unique for a single instance times out, it will trip
>>> that instance only for failover.
>>>
>>> --
>>> Geoff N. Hiten
>>> Senior Database Administrator
>>> Microsoft SQL Server MVP
>>>
>>>
>>> "ronc" <ronc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>>> news:9232DBCF-60C1-4A35-9A96-53594E2BC504@xxxxxxxxxxxxxxxx
>>>> Our production enviornment consists of 2 production servers in an
>>>> active\passive set up. The production enviornment has 3 instances. Is
>>>> it
>>>> possible that a single instance can fail over to the standby node and
>>>> leaving
>>>> the other 2 behind? We think this is happeing but I thought if the
>>>> server
>>>> fails over to the passive server then it would include all 3 instances
>>>> (All
>>>> or nothing)
>>>>
>>>> Thanks
>>>
>>>
>>
>>
>
>


.

Quantcast