Moving virtual server and instance names to a new server

We currently have a (2) node active/active cluster with each node ideally
hosting (2) virtual servers and their instances. We want to split the
cluster into (2) active/passive clusters and move what normally resides on a
given node to it's own cluster. Here is the catch. We have cross
server/instances queries/procedures and Access database/queries with the
Virtual Server and instance name hard coded, and creating new names isn't
really an viable option.
Here is the current setup:
Current Cluster:
NODE01
VSQL1\sqlsrv01
VSQL1\sqlsrv02
NODE02
VSQL1\sqlsrv03
VSQL1\sqlsrv04
And here is the proposed setup::
New Cluster 1:
NODE01 - active
VSQL1\sqlsrv01
VSQL1\sqlsrv02
NODE02 - inactive
New Cluster 2:
NODE01 - active
VSQL1\sqlsrv03
VSQL1\sqlsrv04
NODE02 - inactive
Can we create the servers in a different domain, moving them to our
production domain when testing has been completed? And if so, how do we
handle the fact that the VSQLx and named instances already exists in Active
Directory? Can the old server just be turned off, the new one brought up and
added to the domain by resetting the current domain accounts and re-joining?
Of course. Does anyone have a good solution, I'm all ears. Thanks
> Here is the current setup:
> Current Cluster:
> NODE01
> VSQL1\sqlsrv01
> VSQL1\sqlsrv02
> NODE02
> VSQL1\sqlsrv03
> VSQL1\sqlsrv04
That can't be your current setup. Your current setup is probably more like:
NODE01
VSQL01\sqlsrv01
VSQL02\sqlsrv02
NODE02
VSQL03\sqlsrv03
VSQL04\sqlsrv04
I'd probably just do a switchover with the current cluster. First, get the
necessary database files to a staging server. Then, remove the cluster from
the network. But keep it as your rollback plan. Create two new clusters and
install SQL instances as follows:
New Cluster 1:
NODE01 - active
VSQL01\sqlsrv01
VSQL02\sqlsrv02
NODE02 - inactive
New Cluster 2:
NODE01 - active
VSQL03\sqlsrv03
VSQL04\sqlsrv04
And finally get the database files from the staging server to their
respective new servers.
Linchi
"randall_dh" wrote:

> We currently have a (2) node active/active cluster with each node ideally
> hosting (2) virtual servers and their instances. We want to split the
> cluster into (2) active/passive clusters and move what normally resides on a
> given node to it's own cluster. Here is the catch. We have cross
> server/instances queries/procedures and Access database/queries with the
> Virtual Server and instance name hard coded, and creating new names isn't
> really an viable option.
> Here is the current setup:
> Current Cluster:
> NODE01
> VSQL1\sqlsrv01
> VSQL1\sqlsrv02
> NODE02
> VSQL1\sqlsrv03
> VSQL1\sqlsrv04
>
> And here is the proposed setup::
> New Cluster 1:
> NODE01 - active
> VSQL1\sqlsrv01
> VSQL1\sqlsrv02
> NODE02 - inactive
> New Cluster 2:
> NODE01 - active
> VSQL1\sqlsrv03
> VSQL1\sqlsrv04
> NODE02 - inactive
> Can we create the servers in a different domain, moving them to our
> production domain when testing has been completed? And if so, how do we
> handle the fact that the VSQLx and named instances already exists in Active
> Directory? Can the old server just be turned off, the new one brought up and
> added to the domain by resetting the current domain accounts and re-joining?
> Of course. Does anyone have a good solution, I'm all ears. Thanks
|||Yes, you are correct regarding the Virtual Server naming (careless cutting
and pasting on my part). Ideally, we would like to test the new cluster for
several days prior to bringing it live. My main concern is that the reusing
of the names doesn't cause a problem. Am I correct in my assumtions that AD
isn't involved in the virtual server or instance naming and that the only
network ties are through the DNS entries?
ALso, would you expect that any issues with restoring the master and msdb to
the new cluster instances (any references to the old nodes etc...)?
Thank you.
"Linchi Shea" wrote:
[vbcol=seagreen]
> That can't be your current setup. Your current setup is probably more like:
> NODE01
> VSQL01\sqlsrv01
> VSQL02\sqlsrv02
> NODE02
> VSQL03\sqlsrv03
> VSQL04\sqlsrv04
> I'd probably just do a switchover with the current cluster. First, get the
> necessary database files to a staging server. Then, remove the cluster from
> the network. But keep it as your rollback plan. Create two new clusters and
> install SQL instances as follows:
> New Cluster 1:
> NODE01 - active
> VSQL01\sqlsrv01
> VSQL02\sqlsrv02
> NODE02 - inactive
> New Cluster 2:
> NODE01 - active
> VSQL03\sqlsrv03
> VSQL04\sqlsrv04
> And finally get the database files from the staging server to their
> respective new servers.
> Linchi
> "randall_dh" wrote:

Moving to a new SAN

I have a established cluster that I have to move to
another SAN. Any words of wisdom?
Test, test, test. How are performing the move.
Good luck
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"cgunner" <anonymous@.discussions.microsoft.com> wrote in message
news:02d501c4abd3$ecd50890$a301280a@.phx.gbl...
>I have a established cluster that I have to move to
> another SAN. Any words of wisdom?
|||We are going to go by Q269196 but this does not address
the new LUN's that will have to be setup on the new SAN.
I am mostly concerned with the QUORUM drive. I want to
try to keep the cluster in one piece. Do you know any
other KB's to take into account?

>--Original Message--
>Test, test, test. How are performing the move.
>Good luck
>Cheers,
>Rod
>MVP - Windows Server - Clustering
>http://www.nw-america.com - Clustering
>http://msmvps.com/clustering - Blog
>"cgunner" <anonymous@.discussions.microsoft.com> wrote in
message
>news:02d501c4abd3$ecd50890$a301280a@.phx.gbl...
>
>.
>
|||Sure see
http://www.microsoft.com/resources/d...luad_pr_69.asp
to move the Quorum.
Or do it this way http://support.microsoft.com/?id=280353
Or start all over again - http://support.microsoft.com/?id=245762
More on the quorum http://support.microsoft.com/?id=280345
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"cgunner" <anonymous@.discussions.microsoft.com> wrote in message
news:0d6101c4ac8f$a8f53700$a301280a@.phx.gbl...[vbcol=seagreen]
> We are going to go by Q269196 but this does not address
> the new LUN's that will have to be setup on the new SAN.
> I am mostly concerned with the QUORUM drive. I want to
> try to keep the cluster in one piece. Do you know any
> other KB's to take into account?
> message
|||We just did this on an active / active cluster. If you are using EMC SAn,
they have tools to migrate everything, and to make sure the luns are the
same, and properly assigned to your hosts. You can alos get the data
mirrored, and in sync long before you actually cut over to the new SAN. Our
migration went very smoothly.
"Rodney R. Fournier [MVP]" wrote:

> Sure see
> http://www.microsoft.com/resources/d...luad_pr_69.asp
> to move the Quorum.
> Or do it this way http://support.microsoft.com/?id=280353
> Or start all over again - http://support.microsoft.com/?id=245762
> More on the quorum http://support.microsoft.com/?id=280345
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "cgunner" <anonymous@.discussions.microsoft.com> wrote in message
> news:0d6101c4ac8f$a8f53700$a301280a@.phx.gbl...
>
>
sql

Moving SQL-cluster to a new domain.

Hello,
Articleno: 269196 and 319016 are describing how to move cluster servers to a new domain and changing domain for a SQL2000 failover cluster.
My question is concerning article 319016:
There is a description on how to run the SQL2000 Setup program, altering in registry etc.
But, should I do these operations on both of the nodes or is it enough to do it on only one them ?
Regards
Johnny Lundgren
The SQL Server setup program and Cluster Administrator are cluster aware,
so you should only have to do the steps on one node.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Moving SQL2005 fail-over cluster between domain

Hi everybody,
I'm looking for documentation about moving a fail-over cluster of SQL2005
between different IP network and between difefrent Windows domain.
Some advice ?
Thanks in advance.
Pierluigi
For changing IP addresses, see http://support.microsoft.com/kb/244980.
For changing domains, see http://support.microsoft.com/kb/319016. This is
for SQL2000, but I understand that the steps are similar. But I have not had
any chance to actually change the domains of any SQL2005 cluster, so I have
no direct experience to offer.
Linchi
"Pierluigi" wrote:

> Hi everybody,
> I'm looking for documentation about moving a fail-over cluster of SQL2005
> between different IP network and between difefrent Windows domain.
> Some advice ?
> Thanks in advance.
> Pierluigi
|||Right now, the only supported way to move a SQL 2005 cluster is by
uninstalling and reinstalling.
This is due to the use of domain groups for security management. The
installer is the only tool that sets the permissions correctly.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Pierluigi" <Pierluigi@.discussions.microsoft.com> wrote in message
news:D2AF4817-D33C-423E-BD5F-E009AD591083@.microsoft.com...
> Hi everybody,
> I'm looking for documentation about moving a fail-over cluster of SQL2005
> between different IP network and between difefrent Windows domain.
> Some advice ?
> Thanks in advance.
> Pierluigi

moving sql databases to different server different location

How do I move databases currently on a cluster to a standalone machine with
different drives and location?You can use backup/restore or detach/attach. In the case of backup/restore,
you'll need to use the WITH MOVE option to specify the desired location of
the database files on the target server.
Hope this helps.
Dan Guzman
SQL Server MVP
"nobody" <nobody@.nobody.com> wrote in message
news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
> How do I move databases currently on a cluster to a standalone machine
> with different drives and location?
>|||Hi
"nobody" wrote:

> How do I move databases currently on a cluster to a standalone machine wit
h
> different drives and location?
>
As well as Dan's suggestions you could use sp_detach/sp_attach although this
would mean that your database on the cluster would be down while you copied
the files. See http://support.microsoft.com/kb/314546 also note the part
about orphaned users.
John|||how do you use the move option? I am using the gui and it does not give you
an option
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:8A59927E-2DD6-432F-8348-E32E2FC0A130@.microsoft.com...
> You can use backup/restore or detach/attach. In the case of
> backup/restore, you'll need to use the WITH MOVE option to specify the
> desired location of the database files on the target server.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
>|||Hi
"nobody" wrote:

> how do you use the move option? I am using the gui and it does not give yo
u
> an option
The move options when using Enterprise Manager are on the option tab of the
restore dialog. For a T-SQL example look at example E of the Restore topic i
n
books online or at
http://msdn2.microsoft.com/en-us/library/aa238405(SQL.80).aspx, if the
database already exist on the desitination server, then you may need to add
the REPLACE option. If you are going to do this more than once then having a
script to do it will be easier.
John

moving sql databases to different server different location

How do I move databases currently on a cluster to a standalone machine with
different drives and location?
You can use backup/restore or detach/attach. In the case of backup/restore,
you'll need to use the WITH MOVE option to specify the desired location of
the database files on the target server.
Hope this helps.
Dan Guzman
SQL Server MVP
"nobody" <nobody@.nobody.com> wrote in message
news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
> How do I move databases currently on a cluster to a standalone machine
> with different drives and location?
>
|||how do you use the move option? I am using the gui and it does not give you
an option
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:8A59927E-2DD6-432F-8348-E32E2FC0A130@.microsoft.com...
> You can use backup/restore or detach/attach. In the case of
> backup/restore, you'll need to use the WITH MOVE option to specify the
> desired location of the database files on the target server.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
>
|||Hi
"nobody" wrote:

> how do you use the move option? I am using the gui and it does not give you
> an option
The move options when using Enterprise Manager are on the option tab of the
restore dialog. For a T-SQL example look at example E of the Restore topic in
books online or at
http://msdn2.microsoft.com/en-us/library/aa238405(SQL.80).aspx, if the
database already exist on the desitination server, then you may need to add
the REPLACE option. If you are going to do this more than once then having a
script to do it will be easier.
John

moving sql databases to different server different location

How do I move databases currently on a cluster to a standalone machine with
different drives and location?You can use backup/restore or detach/attach. In the case of backup/restore,
you'll need to use the WITH MOVE option to specify the desired location of
the database files on the target server.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"nobody" <nobody@.nobody.com> wrote in message
news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
> How do I move databases currently on a cluster to a standalone machine
> with different drives and location?
>|||Hi
"nobody" wrote:
> How do I move databases currently on a cluster to a standalone machine with
> different drives and location?
>
As well as Dan's suggestions you could use sp_detach/sp_attach although this
would mean that your database on the cluster would be down while you copied
the files. See http://support.microsoft.com/kb/314546 also note the part
about orphaned users.
John|||how do you use the move option? I am using the gui and it does not give you
an option
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:8A59927E-2DD6-432F-8348-E32E2FC0A130@.microsoft.com...
> You can use backup/restore or detach/attach. In the case of
> backup/restore, you'll need to use the WITH MOVE option to specify the
> desired location of the database files on the target server.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
>> How do I move databases currently on a cluster to a standalone machine
>> with different drives and location?
>|||Hi
"nobody" wrote:
> how do you use the move option? I am using the gui and it does not give you
> an option
The move options when using Enterprise Manager are on the option tab of the
restore dialog. For a T-SQL example look at example E of the Restore topic in
books online or at
http://msdn2.microsoft.com/en-us/library/aa238405(SQL.80).aspx, if the
database already exist on the desitination server, then you may need to add
the REPLACE option. If you are going to do this more than once then having a
script to do it will be easier.
John

Moving SQl cluster to new SAN...

We have two Microsoft Windows 2000/SQL 2000 clusters that need to move from
one SAN to another. The old SAN is going away.
Does anyone know of a procedures or white papers on how to accomplish this.
Dave
Read this excellent blog post -
http://msmvps.com/blogs/clusterhelp/archive/2005/08/05/61741.aspx
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:BDD48A84-20BD-4A29-87DF-94889805A3BB@.microsoft.com...
> We have two Microsoft Windows 2000/SQL 2000 clusters that need to move
> from
> one SAN to another. The old SAN is going away.
> Does anyone know of a procedures or white papers on how to accomplish
> this.
> --
> Dave

Moving SQL Cluster to a new subnet

Hello All,
I need to move a SQL Server Cluster from one subnet to another subnet so I
need to update 5 cluster IP addresses (node a, node b, cluster, SQL Server
and MS DTC). Any help on how to do this would be appreciated.
I found article 230356 explaining how to change the IP address in the nodes
but it is still confusing because it says that "do not work ... if you change
the IP address from one subnet to abother subnet". Then Allan Hirts' book
'SQL High Availability' shows the same procedure (page 190) but says
'Warning: Do not do this unless your servers need to change subnets". Any
idea what the problem is here?
Looks like article 244980 describes how to change the IP address for SQL
Server.
I still need to know how to change the IP address for the cluster and for
MSDTC.
Any help on this?
Thanks,
Benjamin Nevarez
SQL Server Database Administrator
"=?Utf-8?B?QmVuamFtaW4gTmV2YXJleg==?="
<BenjaminNevarez@.discussions.microsoft.com> wrote in
news:782BC7F5-3D71-4543-860B-92F396F9115F@.microsoft.com:

> Looks like article 244980 describes how to change the IP address for
> SQL Server.
Yes, for a virtual server. Exactly what you need, as far as I can see. It
seems to be pretty detailed as well.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
|||The article can be very confusing. The key to remember is that your cluster
always needs a clear communications path for its private communications.
Everything else is optional. Of course, you may be offline for a while
during the transition. Here are a few absolutely key elements
Make sure you have the 'Public" interface enabled for private
communications. Then you can change the private network without losing the
cluster. Once the private side is stable, you can change the public side.
Don't forget the impact of changes on your SAN. It may not like having a
host change IP addresses.
Make sure to read this KB article as well.
How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/kb/244980/
Geoff N. Hiten
Microsoft SQL Server MVP.
"Benjamin Nevarez" <BenjaminNevarez@.discussions.microsoft.com> wrote in
message news:782BC7F5-3D71-4543-860B-92F396F9115F@.microsoft.com...
> Hello All,
> I need to move a SQL Server Cluster from one subnet to another subnet so I
> need to update 5 cluster IP addresses (node a, node b, cluster, SQL Server
> and MS DTC). Any help on how to do this would be appreciated.
> I found article 230356 explaining how to change the IP address in the
> nodes
> but it is still confusing because it says that "do not work ... if you
> change
> the IP address from one subnet to abother subnet". Then Allan Hirts' book
> 'SQL High Availability' shows the same procedure (page 190) but says
> 'Warning: Do not do this unless your servers need to change subnets". Any
> idea what the problem is here?
> Looks like article 244980 describes how to change the IP address for SQL
> Server.
> I still need to know how to change the IP address for the cluster and for
> MSDTC.
> Any help on this?
> Thanks,
> Benjamin Nevarez
> SQL Server Database Administrator
>

Moving SQL 2000 cluster to a different domain

Dear all,
We need to move SQL 2000 Cluster on Win 2003 server box from test to prod
domain. What are the steps we need to follow to make sure SQL 2000 cluster is
up and running in the new domain. I know that we need to change the service
account from window services. Can we change the IP address directly from the
cluster administration window. Any help or link to KM is appreciated.
Thanks
Chinna.
I found the following kb article
http://support.microsoft.com/default...b;en-us;319016
Is this enough to do the task
Thanks in advance!
Chinna.
"Chinna Kondaveeti" wrote:

> Dear all,
> We need to move SQL 2000 Cluster on Win 2003 server box from test to prod
> domain. What are the steps we need to follow to make sure SQL 2000 cluster is
> up and running in the new domain. I know that we need to change the service
> account from window services. Can we change the IP address directly from the
> cluster administration window. Any help or link to KM is appreciated.
> Thanks
> Chinna.

Moving Replication Distributor to new cluster

Hi
What are the gotchas on moving a Replication Distributor to new hardware/a
new cluster?
Kind Regards,
T. Hagen
You have to drop the publications and disable replication on the publisher
before the move. You have to make sure your remote distributor is
clustered - which it appears to be
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"thagen" <thagen@.discussions.microsoft.com> wrote in message
news:23A725E7-ED77-4BD6-A8A6-AF3D91C96D2D@.microsoft.com...
> Hi
> What are the gotchas on moving a Replication Distributor to new hardware/a
> new cluster?
> Kind Regards,
> T. Hagen
|||As well as Hilary's response, and it's a long time since I worked on
clustering a distributor, I recall that the distribution working folder
should be set up as a shared resource on the cluster.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Thanks Hilary.
There is nothing to be done on the Subscriber side?
And as for the actual steps in moving the Distributor, you have any how-to
on that?
Kind Regards,
Torkild
"Hilary Cotter" wrote:

> You have to drop the publications and disable replication on the publisher
> before the move. You have to make sure your remote distributor is
> clustered - which it appears to be
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "thagen" <thagen@.discussions.microsoft.com> wrote in message
> news:23A725E7-ED77-4BD6-A8A6-AF3D91C96D2D@.microsoft.com...
>
>
|||Perhaps you mean the snapshot share While you can park this anywhere, it
is best on the publisher.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uRXwYO8ZHHA.2316@.TK2MSFTNGP04.phx.gbl...
> As well as Hilary's response, and it's a long time since I worked on
> clustering a distributor, I recall that the distribution working folder
> should be set up as a shared resource on the cluster.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
|||You can't move the distributor. You have to disable publishing on the
publisher. Pre-create the distributor on the remote distributor and then
configure your publishers to use this distributor. Then connect to your
publishers and enable replication, and enable it to use the remote
distributor. You will need to configure an administrative link password.
There is a guide in the sample chapter of my book.
http://www.nwsu.com/lowres_replication_ch02.pdf
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"thagen" <thagen@.discussions.microsoft.com> wrote in message
news:3B9C0EF4-E09C-455B-8F5B-9AC1B80BE7D9@.microsoft.com...[vbcol=seagreen]
> Thanks Hilary.
> There is nothing to be done on the Subscriber side?
> And as for the actual steps in moving the Distributor, you have any how-to
> on that?
> Kind Regards,
> Torkild
> "Hilary Cotter" wrote:
|||Yes -thanks for the correction Hilary (snapshot share).
It still makes sense to me though that this should be a shared resource on
the central (shared) array rather than a local node so it can fail over.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Moving Quorum Drive

Hi,
I have a two node failover cluster with two external disk arrays. I have
these two array for some special testing. I no longer need both of them and
need to do some specific testing with just one array. My problem is that the
array I need to test with has all my SQL data but the other array has the
quorum drive. What is the best method to moving the quorum drive to the
other array?
Also, is it possible to have active/active SQL cluster where both SQL
servers (cluster nodes) are sharing the same SQL data files?
Thank you in advance.
Rodney or one of the other Cluster MVPs will have to anwer the quorum disk
move question.
The Active/Active nomenclature is misleading and obsolete. There is no
sharing of data files between SQL instances within a cluster (or anywhere
else for that matter).
Geoff N. Hiten
Microsoft SQL Server MVP
"Dragon" <baadil_nospam@.hotmail.com> wrote in message
news:OAPXqwwgFHA.3312@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have a two node failover cluster with two external disk arrays. I have
> these two array for some special testing. I no longer need both of them
> and need to do some specific testing with just one array. My problem is
> that the array I need to test with has all my SQL data but the other array
> has the quorum drive. What is the best method to moving the quorum drive
> to the other array?
> Also, is it possible to have active/active SQL cluster where both SQL
> servers (cluster nodes) are sharing the same SQL data files?
> Thank you in advance.
>
|||can't help your sql question, but hopefully this will help you to move your
quorum drive
http://support.microsoft.com/default...b;en-us;280353
"Dragon" <baadil_nospam@.hotmail.com> wrote in message
news:OAPXqwwgFHA.3312@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have a two node failover cluster with two external disk arrays. I have
> these two array for some special testing. I no longer need both of them
> and need to do some specific testing with just one array. My problem is
> that the array I need to test with has all my SQL data but the other array
> has the quorum drive. What is the best method to moving the quorum drive
> to the other array?
> Also, is it possible to have active/active SQL cluster where both SQL
> servers (cluster nodes) are sharing the same SQL data files?
> Thank you in advance.
>
|||So does that mean if you need to manage extremely high availability with
900K+ users using SQL, the only option you have is to get beefier boxes? and
live with the 40 second downtime you will get from the cluster failover?
Please note that most of these users are not humans and they know how to
hammer a box :-)
Thanks.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:eHOrQQxgFHA.3936@.TK2MSFTNGP10.phx.gbl...
> Rodney or one of the other Cluster MVPs will have to anwer the quorum disk
> move question.
> The Active/Active nomenclature is misleading and obsolete. There is no
> sharing of data files between SQL instances within a cluster (or anywhere
> else for that matter).
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Dragon" <baadil_nospam@.hotmail.com> wrote in message
> news:OAPXqwwgFHA.3312@.TK2MSFTNGP10.phx.gbl...
>
|||SQL is a scale up not a scale out technology. SQL 2005 has some new tricks
to give you more high availability options, but you are still looking at
buying larger boxes as you outgrow your existing ones. I wouldn't worry too
much, the new TCP-C benchmark released last month by Microsoft is several
times the average daily transaction volume of Visa and it was run on a
single system. Besides, after a certain scale, the disk subsystem and
license costs far outweigh the host computer costs on almost any system,
regardless of which DMBS you are using.
Geoff N. Hiten
Microsoft SQL Server MVP.
"Dragon" <baadil_nospam@.hotmail.com> wrote in message
news:OooBB4ygFHA.3692@.TK2MSFTNGP09.phx.gbl...
> So does that mean if you need to manage extremely high availability with
> 900K+ users using SQL, the only option you have is to get beefier boxes?
> and live with the 40 second downtime you will get from the cluster
> failover? Please note that most of these users are not humans and they
> know how to hammer a box :-)
> Thanks.
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:eHOrQQxgFHA.3936@.TK2MSFTNGP10.phx.gbl...
>
|||"Dragon" <baadil_nospam@.hotmail.com> wrote in message
news:OAPXqwwgFHA.3312@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have a two node failover cluster with two external disk arrays. I have
> these two array for some special testing. I no longer need both of them
> and need to do some specific testing with just one array. My problem is
> that the array I need to test with has all my SQL data but the other array
> has the quorum drive. What is the best method to moving the quorum drive
> to the other array?
The best method of moving the quorum, in my opinion, is to simply use the
GUI. Using the GUI requires that both arrays be visible to the nodes and
that the physical disk that you want to use be also visible to both nodes.
In cluster admin, right click the cluster name, select the Quorum tab and
use the drop down box to select what drive you want to host the quorum.

> Also, is it possible to have active/active SQL cluster where both SQL
> servers (cluster nodes) are sharing the same SQL data files?
Active/active? No. It isn't possible for two instances to share the same
databases and logs.
|||"Dragon" <baadil_nospam@.hotmail.com> wrote in message
news:OooBB4ygFHA.3692@.TK2MSFTNGP09.phx.gbl...
> So does that mean if you need to manage extremely high availability with
> 900K+ users using SQL, the only option you have is to get beefier boxes?
> and live with the 40 second downtime you will get from the cluster
> failover? Please note that most of these users are not humans and they
> know how to hammer a box :-)
You can do both. You can scale up, and you can scale out by using multiple
instances of SQL. However, to scale out, you must be able to break up
databases between the instances. If everyone requires access to the same
database, then you don't have the ability to scale out.
900K+ users? I am only guessing that there are not that many simultaneous
users. How many queries a second are we talking about, just out of
curiosity?
|||Thank you Russ.
I will defo give it a try as soon as I create some space on my DB array. :-)
It sound way to simple. hehe
"Russ Kaufmann" <russ@.nospam.exchangemct.com> wrote in message
news:uyGCMO3gFHA.3448@.TK2MSFTNGP12.phx.gbl...
> "Dragon" <baadil_nospam@.hotmail.com> wrote in message
> news:OAPXqwwgFHA.3312@.TK2MSFTNGP10.phx.gbl...
> The best method of moving the quorum, in my opinion, is to simply use the
> GUI. Using the GUI requires that both arrays be visible to the nodes and
> that the physical disk that you want to use be also visible to both nodes.
> In cluster admin, right click the cluster name, select the Quorum tab and
> use the drop down box to select what drive you want to host the quorum.
>
> Active/active? No. It isn't possible for two instances to share the same
> databases and logs.
>
|||Thank you Seth.
"seth" <seth@.work.net> wrote in message
news:e58ddYxgFHA.4000@.TK2MSFTNGP12.phx.gbl...
> can't help your sql question, but hopefully this will help you to move
> your quorum drive
> http://support.microsoft.com/default...b;en-us;280353
>
> "Dragon" <baadil_nospam@.hotmail.com> wrote in message
> news:OAPXqwwgFHA.3312@.TK2MSFTNGP10.phx.gbl...
>
|||http://www.tpc.org/tpcc/results/tpcc...p?id=105060604
GNH
"Dragon" <baadil_nospam@.hotmail.com> wrote in message
news:ODmlkZ8gFHA.2560@.TK2MSFTNGP10.phx.gbl...
> Thank you Geof. Would you happen to have a link to the benchmark study?
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:eMbN%239ygFHA.3936@.TK2MSFTNGP10.phx.gbl...
>

Moving master database in cluster

Hi
We have SQL 2000 Ent in cluster mode, we move the database in to different
drive and log in to different drive. but now we want to move All the
database (the default one also, which is master, tempdb, etc). (its mainly
for backup purpose, otherwise SAN not supporting)
Ok in this case, how to do that? just stop the sql service and move the
database? it will be fine? or any idea?
Regards
Gopi
Gopi
See this from Microsoft Support pages:-
"How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server" - it gives the details on what to do
with master, msdb, model and tempdb.
http://support.microsoft.com/default...22120121120120
Steve
|||You move them exactly the same way as you would on a standalone machine.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Gopi" <gopigopi@.hotmail.com> wrote in message
news:e%23HoFYxKGHA.964@.tk2msftngp13.phx.gbl...
> Hi
> We have SQL 2000 Ent in cluster mode, we move the database in to different
> drive and log in to different drive. but now we want to move All the
> database (the default one also, which is master, tempdb, etc). (its mainly
> for backup purpose, otherwise SAN not supporting)
> Ok in this case, how to do that? just stop the sql service and move the
> database? it will be fine? or any idea?
> Regards
> Gopi
>

Moving master database in cluster

Hi
We have SQL 2000 Ent in cluster mode, we move the database in to different
drive and log in to different drive. but now we want to move All the
database (the default one also, which is master, tempdb, etc). (its mainly
for backup purpose, otherwise SAN not supporting)
Ok in this case, how to do that? just stop the sql service and move the
database? it will be fine? or any idea?
Regards
GopiGopi
See this from Microsoft Support pages:-
"How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server" - it gives the details on what to do
with master, msdb, model and tempdb.
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071#XSLTH3134121122120121120120
Steve|||You move them exactly the same way as you would on a standalone machine.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Gopi" <gopigopi@.hotmail.com> wrote in message
news:e%23HoFYxKGHA.964@.tk2msftngp13.phx.gbl...
> Hi
> We have SQL 2000 Ent in cluster mode, we move the database in to different
> drive and log in to different drive. but now we want to move All the
> database (the default one also, which is master, tempdb, etc). (its mainly
> for backup purpose, otherwise SAN not supporting)
> Ok in this case, how to do that? just stop the sql service and move the
> database? it will be fine? or any idea?
> Regards
> Gopi
>

Moving master database in cluster

Hi
We have SQL 2000 Ent in cluster mode, we move the database in to different
drive and log in to different drive. but now we want to move All the
database (the default one also, which is master, tempdb, etc). (its mainly
for backup purpose, otherwise SAN not supporting)
Ok in this case, how to do that? just stop the sql service and move the
database? it will be fine? or any idea?
Regards
GopiGopi
See this from Microsoft Support pages:-
"How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server" - it gives the details on what to do
with master, msdb, model and tempdb.
21120120" target="_blank">http://support.microsoft.com/defaul...br />
21120120
Steve|||You move them exactly the same way as you would on a standalone machine.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Gopi" <gopigopi@.hotmail.com> wrote in message
news:e%23HoFYxKGHA.964@.tk2msftngp13.phx.gbl...
> Hi
> We have SQL 2000 Ent in cluster mode, we move the database in to different
> drive and log in to different drive. but now we want to move All the
> database (the default one also, which is master, tempdb, etc). (its mainly
> for backup purpose, otherwise SAN not supporting)
> Ok in this case, how to do that? just stop the sql service and move the
> database? it will be fine? or any idea?
> Regards
> Gopi
>

moving instance on cluster

Hi,
I have a clustered sql server with two instances. It looks like the
disk on one instance is not large enough for the db, whilst the disk
assigned to the other instance has plenty of room. I'd like to swap
disks between instances. How can i move an instance between disks?
Any ideas?
Try Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/default...;en-us;224071, really
pretty easy stuff
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"jmh01" <jmh01@.dslextreme.com> wrote in message
news:1102907117.320981.103110@.c13g2000cwb.googlegr oups.com...
> Hi,
> I have a clustered sql server with two instances. It looks like the
> disk on one instance is not large enough for the db, whilst the disk
> assigned to the other instance has plenty of room. I'd like to swap
> disks between instances. How can i move an instance between disks?
> Any ideas?
>