Re: about another instance of virtual server on sql2000 cluster
- From: <io.com>
- Date: Wed, 12 Oct 2005 22:09:37 +0200
:-)
Thanks for you time.
"Geoff N. Hiten" <sqlcraftsman@xxxxxxxxx> wrote in message
news:uwzLStpzFHA.2132@xxxxxxxxxxxxxxxxxxxxxxx
> Precisely. Multiple instances on a cluster look and act just like
> multiple instances on a stand-alone box. I typically use only named
> instances on a cluster just to avoid naming confusion.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> <io.com> wrote in message news:%233DO2ipzFHA.268@xxxxxxxxxxxxxxxxxxxxxxx
>> Sorry , a lat question :
>>
>> i have isntalled the new virtual server and it work fine but i see that
>> the new instance of sql virtual server is myclustersql02\myclustersql02
>>
>> Why ?
>>
>> The first instance was call only "mycluster01" ....
>> Perhaps because all new instance of virtual server that i install are a
>> "sql named instance" ?
>>
>> Thanks.
>>
>> "Linchi Shea" <linchi_shea@xxxxxxxxxxxx> wrote in message
>> news:ex9%23QsezFHA.3924@xxxxxxxxxxxxxxxxxxxxxxx
>>> No matter whether it's clustered or not, each SQL2000 instance has its
>>> own location for its binaries (well some binaries for the tools are
>>> shared). You can specify the same path, and the install will create a
>>> different folder under that path for each instance. For instance, if you
>>> specify D:\MyDir for the binaries (program files), the install will
>>> place the binaries under D:\MyDir\MSSQL for the default instance, and
>>> under D:\MyDir\MSSQL$<InstanceName> for a named instance.
>>>
>>> Check out the section titled "File Paths for SQL Server 2000" in BOL.
>>>
>>> Also, technically you don't really install another virtual server on the
>>> passive node. Rather, you install another virtual server in the cluster,
>>> and when you install it, the binaries are placed on all the nodes. You
>>> can configure the virtual server to run on a particular node in its
>>> normal operating mode.
>>>
>>> Linchi
>>>
>>> <io.com> wrote in message news:%23c$txrdzFHA.460@xxxxxxxxxxxxxxxxxxxxxxx
>>>> Hi,
>>>>
>>>> i have a cluster a/p windows 2000 & SQL2000 , now i would like install
>>>> another virtual sever SQL on passive node for make this cluster
>>>> active/active.
>>>>
>>>> The question is :
>>>>
>>>> When i start a SQL wizard for add a new virtual server when
>>>> installation wizard aask me a path for sql binary i must use the same
>>>> exist path use for the virtual sql server installed or i must choice
>>>> another path for ex. c:\.....\SQL\Virtual2 ?!?!?
>>>>
>>>> Thanks.
>>>>
>>>>
>>>> --
>>>> ---
>>>>
>>>>
>>>
>>>
>>
>>
>
>
.
- Follow-Ups:
- Re: about another instance of virtual server on sql2000 cluster
- From: Anthony Thomas
- Re: about another instance of virtual server on sql2000 cluster
- References:
- about another instance of virtual server on sql2000 cluster
- From: io.com
- Re: about another instance of virtual server on sql2000 cluster
- From: Linchi Shea
- Re: about another instance of virtual server on sql2000 cluster
- From: io.com
- Re: about another instance of virtual server on sql2000 cluster
- From: Geoff N. Hiten
- about another instance of virtual server on sql2000 cluster
- Prev by Date: Re: Possible to make RS part of a failover Cluster? SQL 2000
- Next by Date: Re: SQL Farm v Clustering
- Previous by thread: Re: about another instance of virtual server on sql2000 cluster
- Next by thread: Re: about another instance of virtual server on sql2000 cluster
- Index(es):
Relevant Pages
|
Loading