s of SQL Server 2000 on the active servers. This SQL Farm will support appro
ximately 150 databases supporting 15 different groups of applications distrb
uted amongst a user populat
ion of 5000 desktops over mutiple sites. Each named instance of SQL Server
will initially host a different subset of the databases. To optimise the se
rver load on each of the 3 active cluster members, over time I want to be ab
le to move the databases su
pporting any particular application group from one server to a different ser
ver in the cluster. Ideally I would like to do this without having to chang
e anything on the client side. I cannot think of any way to do this as I th
ink the client connections
will have to refer to the instance name, which in turn will refer to the vir
tual 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.
quote:
>--Original Message--
>Hi,
>Thank you for using the newsgroup and it is my pleasure
to help you with
quote:
>you issue.
>As my understanding of you question, you want to
optimise the server load
quote:
>within a clustered SQL Server environment and you want
to move the database
quote:
>from one serve to another. If you want to move the
databases from one
quote:
>virtual server to another (in the cluster), you have to
make changes to
quote:
>your client connections as they now need to connect to a
new server that
quote:
>has the databases. The client machines can have alias
that point to a
quote:
>virtual server. In this case, the clients can use the
same alias but still
quote:
>you still have to change alias to point to the new
virtual server after the
quote:
>databases are moved.
>Hope this helps and if you still have questions, please
feel free to post
quote:
>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.
quote:|||Hello Geoff,
>Please reply to newsgroups only. Thanks.
>.
>
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 computers 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.
>to help you with
>optimise the server load
>to move the database
>databases from one
>make changes to
>new server that
>that point to a
>same alias but still
>virtual server after the
>feel free to post
>confers no rights.
>|||Vikrant,
Thanks for your reply. We'd come to the same conclusion but I'm glad it has
been confirmed by you guys.
Cheers
Geoff.
No comments:
Post a Comment