multiple instances in 1 cluster pair (please advise)

Dear all,
I tried to post this question yesterday but seems like didnt get thru,
so I will again. If duplicate, please ignore this.
Currently there I have a live production SQL server cluster (SQL2000) in
non-Case sensitive mode. The server is rather powerful with 8 CPU. Now
only running at 20% cap. Recently we bought a new software and required
the db to be in Case sensitive mode.
It was recommended to create a new instance for the new s/w. Can anyone
help to advise on the following
1) If I create 1 more new instance on the existing DB, how do I
configure it for failover? I cant find any guide to configure the new
instance for failover. Any link to recommend?
2) Any impact I need to note?
Thank you,
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
You don't need a new instance - just a new database. SQL Server 2000 can
have multiple databases, each with its own collation.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Francis Ang" <angcheek@.starhub.net.sg> wrote in message
news:%23Q8AqPn3EHA.3380@.TK2MSFTNGP09.phx.gbl...
Dear all,
I tried to post this question yesterday but seems like didnt get thru,
so I will again. If duplicate, please ignore this.
Currently there I have a live production SQL server cluster (SQL2000) in
non-Case sensitive mode. The server is rather powerful with 8 CPU. Now
only running at 20% cap. Recently we bought a new software and required
the db to be in Case sensitive mode.
It was recommended to create a new instance for the new s/w. Can anyone
help to advise on the following
1) If I create 1 more new instance on the existing DB, how do I
configure it for failover? I cant find any guide to configure the new
instance for failover. Any link to recommend?
2) Any impact I need to note?
Thank you,
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Hi Tom,
Thank you for your reply. I have tried that, although it is working, the
software vendor does not support that configuration. They recommended
new instance. Not sure why either.
Regards,
Francis
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Sounds like the vendor doesn't have much experience with SQL Server 2000.
Well, if they insist, then you're forced to install the extra instance. As
long as you have enough memory and CPU power, then you'll be OK. It's just
that you have to manage two instances, instead of one.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Diamond Star" <Diamond@.Star.com> wrote in message
news:u6hW3Pr3EHA.3316@.tk2msftngp13.phx.gbl...
Hi Tom,
Thank you for your reply. I have tried that, although it is working, the
software vendor does not support that configuration. They recommended
new instance. Not sure why either.
Regards,
Francis
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||But Tom, the DBA dont know how to install a additional instance over the
existing clustered servers. Do you have any guide or link to recommend?
I would really appreciate your help.
Thank you,
Francis Ang
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||It's not that difficult. Just install from the CD as you did for the first
instance. However, the second instance will be a named instance. For
example, if the first instance was called MYSQLSERVER, then you can call the
second one MYSQLSERVER\INST2. The BOL have all the details.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Diamond Star" <Diamond@.Star.com> wrote in message
news:eezVUm33EHA.3336@.TK2MSFTNGP11.phx.gbl...
But Tom, the DBA dont know how to install a additional instance over the
existing clustered servers. Do you have any guide or link to recommend?
I would really appreciate your help.
Thank you,
Francis Ang
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Hi Tom,
THanks for the advise. I will inform the DBA of this. If you dont mind,
I have a last question. Do the DBA set up the Clustering services for
the new instance just like the first instance.
THank you for the help,
Francis
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Since Cluster Services are already set up, you won't need to set it up
again.
One more thing I should add is that the new SQL Server instance will need
its own disks, independent from the first SQL service. Here's what I mean.
Let's say you have 2 physical nodes - NODE1 and NODE2, each with a drive C:
(nonclustered). You have 2 SQL Server instances - SQL1 and SQL2. Both of
these will need a drive for data and another for logs. Thus, you could have
SQL1 with drive D: and E: and SQL2 with drive F: and G:.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Diamond Star" <Diamond@.Star.com> wrote in message
news:unPVf8B4EHA.2404@.TK2MSFTNGP14.phx.gbl...
Hi Tom,
THanks for the advise. I will inform the DBA of this. If you dont mind,
I have a last question. Do the DBA set up the Clustering services for
the new instance just like the first instance.
THank you for the help,
Francis
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Multiple installations of SqlServer on same server.

Hi all,
Can anyone advise on installing multiple versions of
SqlServer 2000 (ver 8) on the same server whilst
maintaining the integrity of previous installations of
SqlServer ?
Thanks in advance.
jTHere are no integrity issues involving multiple instances on the same box,
one instance is independent of the other, with one exception... - they both
will compete for memory. So unless you will be running only one at a time, I
would advise you to set max memory for each instance, assigning the
appropriate memory, so the instances do not compete in this regard...
"jimA" <jima@.pt.lu> wrote in message
news:075a01c35cc1$b7c0df60$a601280a@.phx.gbl...
> Hi all,
> Can anyone advise on installing multiple versions of
> SqlServer 2000 (ver 8) on the same server whilst
> maintaining the integrity of previous installations of
> SqlServer ?
> Thanks in advance.
> j|||You can install multiple instance of SQL 2000 on the same server. Each
is independent and can be at different service pack levels. Only the
tools are shared.
It's generally best to deploy a single instance unless you have a
specific reason to do otherwise, such as special security isolation
requirements or independent test environments. See the Books Online
<architec.chm::/8_ar_cs_5upf.htm> for recommendations. Also note that
licensing restrictions vary by edition.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"jimA" <jima@.pt.lu> wrote in message
news:075a01c35cc1$b7c0df60$a601280a@.phx.gbl...
> Hi all,
> Can anyone advise on installing multiple versions of
> SqlServer 2000 (ver 8) on the same server whilst
> maintaining the integrity of previous installations of
> SqlServer ?
> Thanks in advance.
> j|||Guys,
Many thanks, your comments were much appreciated.
j
>--Original Message--
>Hi all,
>Can anyone advise on installing multiple versions of
>SqlServer 2000 (ver 8) on the same server whilst
>maintaining the integrity of previous installations of
>SqlServer ?
>Thanks in advance.
>j
>.
>