named instances

I am setting up a 3 + 1 Windows 2003 Server cluster hosting 3 named instances of SQL Server 2000 on the active servers. This SQL Farm will support approximately 150 databases supporting 15 different groups of applications distrbuted amongst a user population of 5000 desktops over mutiple sites. Each named instance of SQL Server will initially host a different subset of the databases. To optimise the server load on each of the 3 active cluster members, over time I want to be able to move the databases supporting any particular application group from one server to a different server in the cluster. Ideally I would like to do this without having to change anything on the client side. I cannot think of any way to do this as I think the client connections will have to refer to the instance name, which in turn will refer to the virtual server name. If anyone knows how I can do this I would appreciate your directions. ThanksHi,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
As my understanding of you question, you want to optimise the server load
within a clustered SQL Server environment and you want to move the database
from one serve to another. If you want to move the databases from one
virtual server to another (in the cluster), you have to make changes to
your client connections as they now need to connect to a new server that
has the databases. The client machines can have alias that point to a
virtual server. In this case, the clients can use the same alias but still
you still have to change alias to point to the new virtual server after the
databases are moved.
Hope this helps and if you still have questions, please feel free to post
new message here and I am ready to help!
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Baisong Wei,
Thnaks for your response, from your description you
understand the problem well. To reiterate I would like to
be able to move databases between the named instances
running on the virtual servers and to update the location
by changing something centrally (like a dns alias or a
server side alias) without having to change anything on
the clients. But the only way I can think of doing it is
to make a synchronised change on all the clients as they
have to refer to both the virtual server name and the
instance name. Any ideas?
Thanks
Geoff.
>--Original Message--
>Hi,
>Thank you for using the newsgroup and it is my pleasure
to help you with
>you issue.
>As my understanding of you question, you want to
optimise the server load
>within a clustered SQL Server environment and you want
to move the database
>from one serve to another. If you want to move the
databases from one
>virtual server to another (in the cluster), you have to
make changes to
>your client connections as they now need to connect to a
new server that
>has the databases. The client machines can have alias
that point to a
>virtual server. In this case, the clients can use the
same alias but still
>you still have to change alias to point to the new
virtual server after the
>databases are moved.
>Hope this helps and if you still have questions, please
feel free to post
>new message here and I am ready to help!
>Thanks.
>Best regards
>Baisong Wei
>Microsoft Online Support
>----
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>Please reply to newsgroups only. Thanks.
>.
>|||Hello Geoff,
As per my knowledge, there may not be a central way to achieve this.
Since you want to move the databases to a different virtual server,
you would need to make appropriate changes to the clients connection
strings. It is the same as moving dbs from one SQL Server to another.
Only difference is that you are using virtual SQL Server.Virtual SQL
Servers is for high availability and not for load balancing.
Does that answer you question ?
Thanks for using MSDN Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit
the http://www.microsoft.com/protect site and perform the three
straightforward steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no
rights.
>Content-Class: urn:content-classes:message
>From: <anonymous@.discussions.microsoft.com>
>Sender: <anonymous@.discussions.microsoft.com>
>References: <E539FE0B-030C-4315-8677-41CAD358B95D@.microsoft.com>
<fAHzT4t6DHA.568@.cpmsftngxa07.phx.gbl>
>Subject: RE: named instances
>Date: Wed, 4 Feb 2004 03:16:59 -0800
>Lines: 59
>Message-ID: <0a1901c3eb10$6815d050$3501280a@.phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcPrEGgVFRmJzG6iTB2Kxa9WPaBHUA==>Newsgroups: microsoft.public.sqlserver.server
>Path: cpmsftngxa07.phx.gbl
>Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.server:327510
>NNTP-Posting-Host: tk2msftngxa06.phx.gbl 10.40.1.53
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Baisong Wei,
>Thnaks for your response, from your description you
>understand the problem well. To reiterate I would like to
>be able to move databases between the named instances
>running on the virtual servers and to update the location
>by changing something centrally (like a dns alias or a
>server side alias) without having to change anything on
>the clients. But the only way I can think of doing it is
>to make a synchronised change on all the clients as they
>have to refer to both the virtual server name and the
>instance name. Any ideas?
>Thanks
>Geoff.
>>--Original Message--
>>Hi,
>>Thank you for using the newsgroup and it is my pleasure
>to help you with
>>you issue.
>>As my understanding of you question, you want to
>optimise the server load
>>within a clustered SQL Server environment and you want
>to move the database
>>from one serve to another. If you want to move the
>databases from one
>>virtual server to another (in the cluster), you have to
>make changes to
>>your client connections as they now need to connect to a
>new server that
>>has the databases. The client machines can have alias
>that point to a
>>virtual server. In this case, the clients can use the
>same alias but still
>>you still have to change alias to point to the new
>virtual server after the
>>databases are moved.
>>Hope this helps and if you still have questions, please
>feel free to post
>>new message here and I am ready to help!
>>Thanks.
>>Best regards
>>Baisong Wei
>>Microsoft Online Support
>>----
>>Get Secure! - www.microsoft.com/security
>>This posting is provided "as is" with no warranties and
>confers no rights.
>>Please reply to newsgroups only. Thanks.
>>.
>|||Vikrant
Thanks for your reply. We'd come to the same conclusion but I'm glad it has been confirmed by you guys
Cheer
Geoff.sql