Moving cluster server to new location

We are in the process of migrating our data center to a new location. we
have a cluster server running win2k advance server active passive mode with
Sql server 2000 on it. Any one has any ideas or best practice notes on the
best way to do it.Hi
I guess your IP address wil change:
Changing the IP Address of Network Adapters in Cluster Server
http://support.microsoft.com/default.aspx?kbid=230356
How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/defaul...0&Product=sql2k
Test as much as you can beforehand. Make a checklist before starting.
(Credit to Geoff N. Hiten for the original answer in
microsoft.public.sqlserver.clustering)
Regards
Mike
"sumsuk" wrote:

> We are in the process of migrating our data center to a new location. we
> have a cluster server running win2k advance server active passive mode wit
h
> Sql server 2000 on it. Any one has any ideas or best practice notes on the
> best way to do it.|||Is it better to build a new cluster server at the new site. backup system
and user database from the old server then restore the data on the new
server. Any one had done this , will this work.
If we cannot afford down time then what is the best way to sync. the two
server.
If i am physicaly moving the old server to the new location do you think i
will have to break the cluster because the storage is on a san in the
current location.
My planning is in a very primitive stage now. Any input is apprieciated.
Thanx.
"sumsuk" wrote:

> We are in the process of migrating our data center to a new location. we
> have a cluster server running win2k advance server active passive mode wit
h
> Sql server 2000 on it. Any one has any ideas or best practice notes on the
> best way to do it.sql

Moving cluster server to new location

We are in the process of migrating our data center to a new location. we
have a cluster server running win2k advance server active passive mode with
Sql server 2000 on it. Any one has any ideas or best practice notes on the
best way to do it.Hi
I guess your IP address wil change:
Changing the IP Address of Network Adapters in Cluster Server
http://support.microsoft.com/default.aspx?kbid=230356
How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;244980&Product=sql2k
Test as much as you can beforehand. Make a checklist before starting.
(Credit to Geoff N. Hiten for the original answer in
microsoft.public.sqlserver.clustering)
Regards
Mike
"sumsuk" wrote:
> We are in the process of migrating our data center to a new location. we
> have a cluster server running win2k advance server active passive mode with
> Sql server 2000 on it. Any one has any ideas or best practice notes on the
> best way to do it.|||Is it better to build a new cluster server at the new site. backup system
and user database from the old server then restore the data on the new
server. Any one had done this , will this work.
If we cannot afford down time then what is the best way to sync. the two
server.
If i am physicaly moving the old server to the new location do you think i
will have to break the cluster because the storage is on a san in the
current location.
My planning is in a very primitive stage now. Any input is apprieciated.
Thanx.
"sumsuk" wrote:
> We are in the process of migrating our data center to a new location. we
> have a cluster server running win2k advance server active passive mode with
> Sql server 2000 on it. Any one has any ideas or best practice notes on the
> best way to do it.

Moving cluster server to new location

We are in the process of migrating our data center to a new location. we
have a cluster server running win2k advance server active passive mode with
Sql server 2000 on it. Any one has any ideas or best practice notes on the
best way to do it.
Hi
I guess your IP address wil change:
Changing the IP Address of Network Adapters in Cluster Server
http://support.microsoft.com/default.aspx?kbid=230356
How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/default...&Product=sql2k
Test as much as you can beforehand. Make a checklist before starting.
(Credit to Geoff N. Hiten for the original answer in
microsoft.public.sqlserver.clustering)
Regards
Mike
"sumsuk" wrote:

> We are in the process of migrating our data center to a new location. we
> have a cluster server running win2k advance server active passive mode with
> Sql server 2000 on it. Any one has any ideas or best practice notes on the
> best way to do it.
|||Is it better to build a new cluster server at the new site. backup system
and user database from the old server then restore the data on the new
server. Any one had done this , will this work.
If we cannot afford down time then what is the best way to sync. the two
server.
If i am physicaly moving the old server to the new location do you think i
will have to break the cluster because the storage is on a san in the
current location.
My planning is in a very primitive stage now. Any input is apprieciated.
Thanx.
"sumsuk" wrote:

> We are in the process of migrating our data center to a new location. we
> have a cluster server running win2k advance server active passive mode with
> Sql server 2000 on it. Any one has any ideas or best practice notes on the
> best way to do it.

moving away from cluster to standalone

We have 2 servers on a SQL 2000 cluster and now we would like to move away
from a clustered enviroment to just a standalone machine. Any idea how I
should proceed?
"nobody" <nobody@.nobody.com> wrote in message
news:%231FAGluoHHA.4424@.TK2MSFTNGP03.phx.gbl...
> We have 2 servers on a SQL 2000 cluster and now we would like to move away
> from a clustered enviroment to just a standalone machine. Any idea how I
> should proceed?
Build a new server, install SQL, and migrate databases.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
July 10-13 in Denver
July 16-19 in New York
|||Agreed, there is no procedure for converting a clustered install to a
standalone install.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)
"Russ Kaufmann [MVP]" wrote:

> "nobody" <nobody@.nobody.com> wrote in message
> news:%231FAGluoHHA.4424@.TK2MSFTNGP03.phx.gbl...
> Build a new server, install SQL, and migrate databases.
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
> The next ClusterHelp classes are:
> July 10-13 in Denver
> July 16-19 in New York
>

Moving a Windows 2003 Cluster to a New Forest

I am looking to decomission an old AD forest and move all it's resources to a
new AD forest. Both forests exist today. I have a 2 node Windows 2003
cluster with 3 resource groups -- the cluster resource group and two (2) SQL
2000 server resource groups.
My questions are...
1) Is this sort of migration possible/support?
2) If so, how do I go about doing it (or finding out how to do it).
Thanks.
Bill
How to change domains for a SQL Server 2000 or SQL Server 2005 failover
cluster
http://support.microsoft.com/kb/319016/en-us
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Bill J." <Bill J.@.discussions.microsoft.com> wrote in message
news:77BA4242-BDBB-4A83-9A46-52F57A055F2F@.microsoft.com...
>I am looking to decomission an old AD forest and move all it's resources to
>a
> new AD forest. Both forests exist today. I have a 2 node Windows 2003
> cluster with 3 resource groups -- the cluster resource group and two (2)
> SQL
> 2000 server resource groups.
> My questions are...
> 1) Is this sort of migration possible/support?
> 2) If so, how do I go about doing it (or finding out how to do it).
> Thanks.
> Bill
sql

Moving a SQL Server 2K cluster to new subet

Hi, I need to move a MSCS cluster running SQL Server 2000 Enterprise
Edition to a new subnet. Can anyone point me to or list what items I need to
be aware of in order for me to move my cluster?
Thanks
It's really not that bad, see http://support.microsoft.com/?id=244980 for
the clicks.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Jose Lopez-Alvarez" <jose.lopez-alvarez@.ftb.ca.gov> wrote in message
news:%23dlhyChkEHA.536@.TK2MSFTNGP11.phx.gbl...
> Hi, I need to move a MSCS cluster running SQL Server 2000 Enterprise
> Edition to a new subnet. Can anyone point me to or list what items I need
> to
> be aware of in order for me to move my cluster?
>
> Thanks
>
>
sql

Moving a SQL Server 2005 Cluster from one Domain to another

First, Can you move a SQL Server 2005 Cluster from one active directory domain to another? If so, what are the steps in moving a SQL Server 2005 Cluster from one domain to another?

Are there any concerns in attempting that move? I know that the domain groups are a hard dependency and that you cannot change them without doing a full reinstall. Does this have any bearing to moving a cluster between domains?

Thank you in advance for you assistance.

David P

Hey David...did you review the following 2 kb articles, they lay the process and possible pitfalls out pretty well:

How to move a Windows Cluster Server from one domain to another

http://support.microsoft.com/kb/269196/

How to change domains for a SQL Server 2000 or SQL Server 2005 failover cluster

http://support.microsoft.com/default.aspx/kb/319016/en-us#appliesto

If you review and have further questions, just post back.

HTH

Moving a Full-Text Catalog from a single server to a Cluster

Hi,
I was wondering if anyone could point me in the right direction with a
problem I'm having moving a full-text catalog from one server to
another.
In a nutshell, I want to take a database with full-text indexing
enabled and move it and the catalog to a new server. The existing
system is a single server build but the new one will be clustered in
an active/passive configuration which complicates things a little.
Obviously I've read and tried the instructions in Q240867 but this
doesnt seem to have worked and a full population starts as soon as I
enable the funtionality again (so either I'm doing something wrong or
it's not possible to do it).
I've tried to follow the instructions on each of the nodes in the
cluster and on the virtual server but it doesnt seem to work.
Any help anyone can give me in this would be really appreciated.
Regards,
Mike
Are the database IDs identical on the server you are moving the catalogs to?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Mike" <mike.metcalf@.4projects.com> wrote in message
news:678e073d.0410180336.37c55f97@.posting.google.c om...
> Hi,
> I was wondering if anyone could point me in the right direction with a
> problem I'm having moving a full-text catalog from one server to
> another.
> In a nutshell, I want to take a database with full-text indexing
> enabled and move it and the catalog to a new server. The existing
> system is a single server build but the new one will be clustered in
> an active/passive configuration which complicates things a little.
> Obviously I've read and tried the instructions in Q240867 but this
> doesnt seem to have worked and a full population starts as soon as I
> enable the funtionality again (so either I'm doing something wrong or
> it's not possible to do it).
> I've tried to follow the instructions on each of the nodes in the
> cluster and on the virtual server but it doesnt seem to work.
> Any help anyone can give me in this would be really appreciated.
> Regards,
> Mike
|||Hi Hillary,
I've had a look and the DBID's are the same (I thought they were but
it's always worth double-checking), the only thing that should be
diffent is that the new build will be clustered (the old one isnt) and
the FTDATA directory is being moved from the c: to the shared d: (I've
updated the registry keys to reflect the new location)
What I'm really looking for is someone to tell me where I need to apply
the registry settings I took on the original system to (node 1, node 2,
virtual server, virtual SQL Server or some mix of everything), or
failing that if someone could say if and why it wasn't possible (I'm
fairly sure it is) that would be ok too.
There's probably something different (or extra) that needs doing on a
clustered installation that hasnt been documented yet.
Mike
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Mike,
I researched and wrote the original KB article Q240867 (before it was
modified for SP3) and because you're moving from a non-clustered environment
to a clustered environment, this modified KB article's cluster related
procedures assumes that you are already in a clustered environment before
moving or copying the FT Catalog folder & files.
I'd recommend that you review KB article 812666 - "How to recover a failed
full-text search resource on a clustered instance of SQL Server 2000" at
http://support.microsoft.com/default.aspx?kbid=812666 if re-installation of
FTS is required. If not, I'd recommend that you consider setting up your
clustered environment first and then copy over the SQL000<dbid>000<ftcatid>
folder assuming the same dibd & ftcatid is on your clustered environment. If
this is not possible, then you most likely will have to run a Full
Population and take the hit on a long population period as I'm assuming that
is why you are copying to the new build from the old non-clustered build.
Regards,
John
"Mike Metcalf" <mike.metcalf@.4projects.com> wrote in message
news:uSzxk0StEHA.1400@.TK2MSFTNGP11.phx.gbl...
> Hi Hillary,
> I've had a look and the DBID's are the same (I thought they were but
> it's always worth double-checking), the only thing that should be
> diffent is that the new build will be clustered (the old one isnt) and
> the FTDATA directory is being moved from the c: to the shared d: (I've
> updated the registry keys to reflect the new location)
> What I'm really looking for is someone to tell me where I need to apply
> the registry settings I took on the original system to (node 1, node 2,
> virtual server, virtual SQL Server or some mix of everything), or
> failing that if someone could say if and why it wasn't possible (I'm
> fairly sure it is) that would be ok too.
> There's probably something different (or extra) that needs doing on a
> clustered installation that hasnt been documented yet.
> Mike
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Hi John,
Thanks for your suggestions, I had a look at the article over the
weekend and a combination of the two led me to the correct solution,
I've tested it 3 times and it's worked each time so I know it's not a
fluke.
Thanks again,
Mike
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||You're welcome, Mike,
I guess a little bit of persistence goes a long way!
John
"Mike Metcalf" <mike.metcalf@.4projects.com> wrote in message
news:#49OMjmuEHA.2832@.tk2msftngp13.phx.gbl...
> Hi John,
> Thanks for your suggestions, I had a look at the article over the
> weekend and a combination of the two led me to the correct solution,
> I've tested it 3 times and it's worked each time so I know it's not a
> fluke.
> Thanks again,
> Mike
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>
sql

Moving a cluster out of a domain

I need to move my cluster out of a domain and into a
workgroup. Is there any documentation available on this
procedure? So far an online search has come up empty.
You must have a domain (AD or NT4) for a cluster. The cluster needs a
common security context for all the services to work correctly. You cannot
run a cluster in a workgroup environment.
Geoff N. Hiten
Microsoft SQL Server MVP.
"Scott" <anonymous@.discussions.microsoft.com> wrote in message
news:195901c55498$4652f090$a601280a@.phx.gbl...
>I need to move my cluster out of a domain and into a
> workgroup. Is there any documentation available on this
> procedure? So far an online search has come up empty.
|||The cluster was originally set up by Dell when we got the
hardware in a workgroup. Unfortunately our support with
them has expired which is why I am searching online.
I believe they had a DNS server running on the cluster that
allowed it to work.

>--Original Message--
>You must have a domain (AD or NT4) for a cluster. The
cluster needs a
>common security context for all the services to work
correctly. You cannot
>run a cluster in a workgroup environment.
>Geoff N. Hiten
>Microsoft SQL Server MVP.
>
>"Scott" <anonymous@.discussions.microsoft.com> wrote in
message
>news:195901c55498$4652f090$a601280a@.phx.gbl...
>
>.
>
|||Doesn't change the fact that you must have a domain account for the cluster
service account. If you wish to move from one domain to another, you should
read the following KB for details about recreating the cluster service
account:
http://support.microsoft.com/kb/269229
Again, MSCS does not work in a workgroup.
Regards,
John
<anonymous@.discussions.microsoft.com> wrote in message
news:15ab01c5549b$e4c8b4f0$a401280a@.phx.gbl...[vbcol=seagreen]
> The cluster was originally set up by Dell when we got the
> hardware in a workgroup. Unfortunately our support with
> them has expired which is why I am searching online.
> I believe they had a DNS server running on the cluster that
> allowed it to work.
> cluster needs a
> correctly. You cannot
> message

Move transaction logs in SQL cluster

Hi
I need to move the transaction logs for all the sql db's (including master,
model and user db's etc) to a seperate drive. Does anyone have any experience
doing this in a sql cluster?
Thanks
Parky
Parky wrote:
> Hi
> I need to move the transaction logs for all the sql db's (including
> master, model and user db's etc) to a seperate drive. Does anyone
> have any experience doing this in a sql cluster?
There is no difference if you move t-log in a single box machine or in a
cluster environment.
You have to pay attention to move db files ONLY on shared disk and modify,
using EM, the switch -l in startup properties of SQL Server and assign them
the new location of t-log of master database

> Thanks
Bye
Luca Bianchi
Microsoft MVP - SQL Server
http://mvp.support.microsoft.com
http://italy.mvps.org
|||Hello Parky,
I agree with Luca. There is no difference between moving the db files on a standalone SQL server v/s clustered SQL Server. One difference is that the shared dirve where you want to move the db files should be in
the dependency list of SQL Server resource. (For Ex. Say you want to move the Tlogs to a shared drive F:. Make sure that SQL Server resource has F: as a dependency. If not you will have have make it. Note that
this requires a downtime as you will have to take SQL Server resource offline, add the shared drive as a dependency and then take SQL Server online. Then you can use your usual steps (see
http://support.microsoft.com/kb/224071/EN-US/
INF: Moving SQL Server Databases to a New Location using Detach/Attach )
If you have never done this on a cluster, I will recommend you to practice the steps on a test SQL Cluster or a cluster using virtual technology.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I would leave the System databases and there log file on one drive and split
the user databases to two diffrent databases, that way is you losse the log
drive you can still get sql server running and manage it to recreate the user
databases from the datafiles with diffrent location of the log files.
"Uttam Parui[MS]" wrote:

> Hello Parky,
> I agree with Luca. There is no difference between moving the db files on a standalone SQL server v/s clustered SQL Server. One difference is that the shared dirve where you want to move the db files should be in
> the dependency list of SQL Server resource. (For Ex. Say you want to move the Tlogs to a shared drive F:. Make sure that SQL Server resource has F: as a dependency. If not you will have have make it. Note that
> this requires a downtime as you will have to take SQL Server resource offline, add the shared drive as a dependency and then take SQL Server online. Then you can use your usual steps (see
> http://support.microsoft.com/kb/224071/EN-US/
> INF: Moving SQL Server Databases to a New Location using Detach/Attach )
> If you have never done this on a cluster, I will recommend you to practice the steps on a test SQL Cluster or a cluster using virtual technology.
> HTH,
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>

Move SQL Server cluster between SANs

Is there a proven way of how to do it?
I myself didnt find any document on that. But I can tell you that I
succefully did that 2 weeks ago on >> windows 2003 <<.
Assumptions:
1) The machines will not change
2) The storage will be changed
3) the 2 SANs will be accessible to the cluster for the migration purpose.
4) assume the Old disk drive is O: and the New disk Drive is N:
Steps I followed:
1) Backed the disks up
2) Backed the disk signatures/geometry. You can use "confdisk.exe" to do
that.
3) On the new SAN create a new partition that you will use for the SQL. Name
the disk N:\
4) Create a new Disk Resource for the new disk and have that in the SQL
group.
5) Offline the SQL resource (so that no one would be writing to the disk
anymore)
6) Keep the disk resources online.
7) using a copy utility replicate the data from the old drive to the new
drive, make sure to copy the correct ACL's/attributes/etc...
The " /o " switch with xcopy does copy the ACL's. You can also ntbackup then
restore the data. Whatever you are comfortable with to replicate the data.
8) Now Add the new disk as a dependency for the SQL resource. The SQL
resource at this point of time will have 2 disk dependencies: Disk O: and
Disk N:
9) Go to disk management. Rename the Old disk drive from O: to X:
10) Rename the New disk drive from N: to O:
11) back to cluster administrator, rename the resource from "Disk O:" to
"Disk X:"
12) rename the resource from "Disk N:" to "Disk O:"
13) remove the "Disk X:" dependency from the SQL resource. Now it should
only have one disk dependency "disk O:"
14) I would go to the advanced properties of the SQL resource, and set it to
"Do not restart".
(just in case things dont go well, you dont want the resource failing back
in forth between the nodes)
15) try to online the SQL resource
Does it work?
The go back to Advanced tab in properties and set it to "Restart"
Does it fail?
Go the event viewer and check the system and the application events. Does it
shed any light on the problem?
Thanks,
Loay Shbeilat
MSCS Admin Tools STE
"This posting is provided "AS IS" with no warranties, and confers no
rights."
"Bjorn Mobak" <anonymous@.discussions.microsoft.com> wrote in message
news:1436301c41bac$9a6fce80$a001280a@.phx.gbl...
> Hi.
> I'm in the process of migrating from a HP XP SAN to an
> EVA5000. The big issue is how to transfer the SQL Server
> disks.
> My plan is to give the cluster access to disks on both
> nodes. Change the Quorum drive to the EVA quorum disk.
> Then the fun part starts.
> Is there a proven path for how to move the SQL Server
> disks onto the new SAN?
> Thanks for any suggestions.
> Bjorn Mobak
> Avinor AS
> Norway
Great!
I have switched SAN and it went smooth as silk.
The only scare was to change the soft-zoning on the
fabric. Haven't done that before :-)
Thank you.
Bjorn

>--Original Message--
>Is there a proven way of how to do it?
>I myself didnt find any document on that. But I can tell
you that I
>succefully did that 2 weeks ago on >> windows 2003 <<.
>Assumptions:
>1) The machines will not change
>2) The storage will be changed
>3) the 2 SANs will be accessible to the cluster for the
migration purpose.
>4) assume the Old disk drive is O: and the New disk
Drive is N:
>Steps I followed:
>1) Backed the disks up
>2) Backed the disk signatures/geometry. You can
use "confdisk.exe" to do
>that.
>3) On the new SAN create a new partition that you will
use for the SQL. Name
>the disk N:\
>4) Create a new Disk Resource for the new disk and have
that in the SQL
>group.
>5) Offline the SQL resource (so that no one would be
writing to the disk
>anymore)
>6) Keep the disk resources online.
>7) using a copy utility replicate the data from the old
drive to the new
>drive, make sure to copy the correct
ACL's/attributes/etc...
>The " /o " switch with xcopy does copy the ACL's. You can
also ntbackup then
>restore the data. Whatever you are comfortable with to
replicate the data.
>8) Now Add the new disk as a dependency for the SQL
resource. The SQL
>resource at this point of time will have 2 disk
dependencies: Disk O: and
>Disk N:
>9) Go to disk management. Rename the Old disk drive
from O: to X:
>10) Rename the New disk drive from N: to O:
>11) back to cluster administrator, rename the resource
from "Disk O:" to
>"Disk X:"
>12) rename the resource from "Disk N:" to "Disk O:"
>13) remove the "Disk X:" dependency from the SQL
resource. Now it should
>only have one disk dependency "disk O:"
>14) I would go to the advanced properties of the SQL
resource, and set it to
>"Do not restart".
> (just in case things dont go well, you dont want the
resource failing back
>in forth between the nodes)
>15) try to online the SQL resource
>Does it work?
>The go back to Advanced tab in properties and set it
to "Restart"
>Does it fail?
>Go the event viewer and check the system and the
application events. Does it
> shed any light on the problem?
>
>--
>Thanks,
>Loay Shbeilat
>MSCS Admin Tools STE
>"This posting is provided "AS IS" with no warranties, and
confers no
>rights."
>"Bjorn Mobak" <anonymous@.discussions.microsoft.com> wrote
in message
>news:1436301c41bac$9a6fce80$a001280a@.phx.gbl...
>
>.
>
|||happy to hear that :-)
Thanks,
Loay Shbeilat
MSCS Admin Tools STE
"This posting is provided "AS IS" with no warranties, and confers no
rights."
"Bjorn Mobak" <anonymous@.discussions.microsoft.com> wrote in message
news:1925901c41c25$17b5bad0$a301280a@.phx.gbl...
> Great!
> I have switched SAN and it went smooth as silk.
> The only scare was to change the soft-zoning on the
> fabric. Haven't done that before :-)
> Thank you.
> Bjorn
> you that I
> migration purpose.
> Drive is N:
> use "confdisk.exe" to do
> use for the SQL. Name
> that in the SQL
> writing to the disk
> drive to the new
> ACL's/attributes/etc...
> also ntbackup then
> replicate the data.
> resource. The SQL
> dependencies: Disk O: and
> from O: to X:
> from "Disk O:" to
> resource. Now it should
> resource, and set it to
> resource failing back
> to "Restart"
> application events. Does it
> confers no
> in message
|||Make sure you are using all the latest HBA drivers, EVA software, Secure Path software and switch firmware, else you'll run into stability problems with EVA5000s.

move log file to diff location

Hi,
I got this error when I move the log file to a diff location in the cluster
environment.
Any ideas and solution?
Thanks
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'T:\Logs\myrpdLog.ldf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
can be used.Please don't multi-post. See my answer in .clustering.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23lg8C4luHHA.1768@.TK2MSFTNGP04.phx.gbl...
Hi,
I got this error when I move the log file to a diff location in the cluster
environment.
Any ideas and solution?
Thanks
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'T:\Logs\myrpdLog.ldf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
can be used.

Move from active/passive cluster to active/active

Hi,
sorry for my lack of knowledge on this issue..
I've installed a Windows 2003 Cluster with SQL 2005. Works like a charm
when i do a failover.
Now i want to make this cluster active/active (multi instance) so no
connection is lost when a node goes down, but can't find any info on
how this need to be done. Can anyone help me out here..?!
Thanx in advance!
Hiddo,
"to make this cluster active/active (multi instance) so no connection is
lost when a node goes down"
When a cluster-group, or instance, moves from one node to another you do
loose your connection, as it offlines the group completely when moving.
Having a multi-instance, doesn't help, multi-instance is just another word
for having multiple virtual servers, they are still seperate in regards to
databases and connections. (e.g. if you have 2 instances, you can consider
them as being 2 different servers)
I do not think that your problem can be solved by server clustering.
HTH,
_Edwin.
<hiddo.vanloon@.gmail.com> wrote in message
news:1166449613.633338.27770@.t46g2000cwa.googlegro ups.com...
> Hi,
> sorry for my lack of knowledge on this issue..
> I've installed a Windows 2003 Cluster with SQL 2005. Works like a charm
> when i do a failover.
> Now i want to make this cluster active/active (multi instance) so no
> connection is lost when a node goes down, but can't find any info on
> how this need to be done. Can anyone help me out here..?!
> Thanx in advance!
>
|||a Network Load balanced cluster is something then a multi instance
cluster right?!
hiddo.vanloon@.gmail.com schreef:

> Hi,
> sorry for my lack of knowledge on this issue..
> I've installed a Windows 2003 Cluster with SQL 2005. Works like a charm
> when i do a failover.
> Now i want to make this cluster active/active (multi instance) so no
> connection is lost when a node goes down, but can't find any info on
> how this need to be done. Can anyone help me out here..?!
> Thanx in advance!
|||NLB is indeed different then failover clustering, however not really usable
with databases such as SQL.
You need to think of your requirements, and then match it to the right
technology option for SQL
Here are some links for reference:
(some are SQL2000, but still applicable for most part)
Failover Clustering
http://msdn2.microsoft.com/en-gb/library/ms189134.aspx
SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
Scaling Out SQL Server with Data Dependent Routing
http://www.microsoft.com/technet/prodtechnol/sql/2005/scddrtng.mspx
Federated SQL Server 2000 Servers
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_4fw3.asp
Federated Database Servers
http://msdn2.microsoft.com/en-us/library/ms190381.aspx
Scaling out SQL 2005
http://msdn2.microsoft.com/en-us/library/aa479364.aspx
HTH,
Rgds,
Edwin.
<hiddo.vanloon@.gmail.com> wrote in message
news:1166450266.512747.218020@.l12g2000cwl.googlegr oups.com...
> a Network Load balanced cluster is something then a multi instance
> cluster right?!
> hiddo.vanloon@.gmail.com schreef:
>
|||Edwin,
Thanx for your support! It's become more clear to me now...
Nog 1 vraag ... : )
Hoe verwijder ik een Windows 2003 cluster in z'n geheel. Ik draai (voor
test) een 2-node W2k3/SQL2k5 cluster en deze wil ik dus in z'n geheel
verwijderen.
Wanneer ik op de eerst node 'take offline' kies en vervolgens Evict
Node gaat dit goed, alleen bij de 2de node krijg ik RPC errors
(waarschijnlijk omdat hierop het virtuele cluster ip nog draait..)
Gr,
Hiddo
Edwin vMierlo schreef:
[vbcol=seagreen]
> NLB is indeed different then failover clustering, however not really usable
> with databases such as SQL.
> You need to think of your requirements, and then match it to the right
> technology option for SQL
> Here are some links for reference:
> (some are SQL2000, but still applicable for most part)
> Failover Clustering
> http://msdn2.microsoft.com/en-gb/library/ms189134.aspx
> SQL Server 2000 Failover Clustering
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
> Scaling Out SQL Server with Data Dependent Routing
> http://www.microsoft.com/technet/prodtechnol/sql/2005/scddrtng.mspx
> Federated SQL Server 2000 Servers
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_4fw3.asp
> Federated Database Servers
> http://msdn2.microsoft.com/en-us/library/ms190381.aspx
> Scaling out SQL 2005
> http://msdn2.microsoft.com/en-us/library/aa479364.aspx
>
> HTH,
> Rgds,
> Edwin.
>
> <hiddo.vanloon@.gmail.com> wrote in message
> news:1166450266.512747.218020@.l12g2000cwl.googlegr oups.com...
|||Hiddo,
Good practice is to keep posts in these newsgroups in english. This so
others can read the posts and possibly help themselves solving problems.
There are however some newsgroups for some topics in your native language,
they have the microsoft.public.nl.... prefix.
In regards to your question of fully removing a W2K3/SQL2K5 cluster,
first, remove SQL instances:
http://msdn2.microsoft.com/en-us/library/ms190438.aspx
then, remove the cluster:
http://support.microsoft.com/kb/282227
Good Luck !
Rgds,
Edwin.
<hiddo.vanloon@.gmail.com> wrote in message
news:1166452564.987411.275060@.n67g2000cwd.googlegr oups.com...[vbcol=seagreen]
> Edwin,
> Thanx for your support! It's become more clear to me now...
> Nog 1 vraag ... : )
> Hoe verwijder ik een Windows 2003 cluster in z'n geheel. Ik draai (voor
> test) een 2-node W2k3/SQL2k5 cluster en deze wil ik dus in z'n geheel
> verwijderen.
> Wanneer ik op de eerst node 'take offline' kies en vervolgens Evict
> Node gaat dit goed, alleen bij de 2de node krijg ik RPC errors
> (waarschijnlijk omdat hierop het virtuele cluster ip nog draait..)
> Gr,
> Hiddo
>
> Edwin vMierlo schreef:
usable[vbcol=seagreen]
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx[vbcol=seagreen]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_4fw3.asp[vbcol=seagreen]
charm
>