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!