Change IP address and subnet of Cluster nodes

I have two node SQL 2005 Cluster on Windows 2003 SP1. Now, I have to change
both IP address and subnet Windows Cluster servers.
is it possible? or What can I do step-by-step?
thanks
"TUFAN ODUNCU" <TUFANODUNCU@.discussions.microsoft.com> wrote in message
news:AF919426-25AC-4D68-AE1D-214729F868EE@.microsoft.com...
>I have two node SQL 2005 Cluster on Windows 2003 SP1. Now, I have to change
> both IP address and subnet Windows Cluster servers.
> is it possible? or What can I do step-by-step?
> thanks
Per Ryan in the other cluster newsgroup...
Changing the IP address of network adapters in cluster server
http://support.microsoft.com/kb/230356
How to change the network IP addresses of SQL Server failover cluster
instances
http://support.microsoft.com/kb/244980
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
Sep 3 - 6 in Copenhagen

Change Domains

I need to move a Win2k/SQL2k 2-node cluster to another Domain. I'm
considering two alternatives: (a) a node by node rebuild to a Win2k3/SQL2k
cluster in the new Domain, and (b) migrating MSCS to the new domain per
kb26196: "How to Move a Windows Cluster Server from one domain to another",
and then using SQL Server's Setup program, Cluster Administrator, and
regedt32 to migrate the instances to the new domain, per per kb319016: "How
To: Change Doamins for a SQL Server 2000 Failover Cluster". Any advice?
I had to do this recently. I start from scratch and then attached the
databases. Worked great.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Harvey Hall" <Harvey Hall@.discussions.microsoft.com> wrote in message
news:F21C09DF-36F2-4AF4-B50A-B71D9ACDDBDF@.microsoft.com...
>I need to move a Win2k/SQL2k 2-node cluster to another Domain. I'm
> considering two alternatives: (a) a node by node rebuild to a Win2k3/SQL2k
> cluster in the new Domain, and (b) migrating MSCS to the new domain per
> kb26196: "How to Move a Windows Cluster Server from one domain to
> another",
> and then using SQL Server's Setup program, Cluster Administrator, and
> regedt32 to migrate the instances to the new domain, per per kb319016:
> "How
> To: Change Doamins for a SQL Server 2000 Failover Cluster". Any advice?
|||Thanks for your response. Glad to hear that "from scratch" works well. Do you
have any thoughts about what I call plan (b) below, that is:
(b) migrating MSCS to the new domain per kb26196: "How to Move a Windows
Cluster Server from one domain to another", and then using SQL Server's Setup
program, Cluster Administrator, and regedt32 to migrate the instances to the
new domain, per kb319016: "How To: Change Domains for a SQL Server 2000
Failover Cluster"
Would you recommend one approach over another?
"Harvey Hall" wrote:
I need to move a Win2k/SQL2k 2-node cluster to another Domain. I'm
considering two alternatives: (a) a node by node rebuild to a Win2k3/SQL2k
cluster in the new Domain, and (b) migrating MSCS to the new domain per
kb26196: "How to Move a Windows Cluster Server from one domain to another",
and then using SQL Server's Setup program, Cluster Administrator, and
regedt32 to migrate the instances to the new domain, per per kb319016: "How
To: Change Doamins for a SQL Server 2000 Failover Cluster". Any advice?
|||Hello Harvey,
With regards to the options I would utilise the option of building from
scratch if this option is available to you as this will gurantee you that
setup is clean, whereas with the migration option using the KB artilces you
have specified you can run into issues which can be caused by objects not
being created during the migration, etc; service account issues, etc.
However the KB articles are tested and proven to work but as is with most
cases if you can start from scratch its always better, especially in a
cluster environment where you want to gurantee a clean environment for high
availability and ease of troubleshooting.
Regards,
Shashank Pawar
SQL Server Support Engineer, Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Change Domains
| thread-index: AcTZXDH2uVyKQNVbSwSq4yvHs8qoUw==
| X-WBNR-Posting-Host: 69.89.128.5
| From: "=?Utf-8?B?SGFydmV5IEhhbGw=?="
<HarveyHall@.discussions.microsoft.com>
| References: <F21C09DF-36F2-4AF4-B50A-B71D9ACDDBDF@.microsoft.com>
| Subject: RE: Change Domains
| Date: Fri, 3 Dec 2004 09:19:07 -0800
| Lines: 20
| Message-ID: <011FD8E0-BBF7-4040-B2BD-1A9098C71D6D@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.clustering
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFT NGXA01.phx.gbl!TK2MSFTNGXA
03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.clustering:15918
| X-Tomcat-NG: microsoft.public.sqlserver.clustering
|
| Thanks for your response. Glad to hear that "from scratch" works well. Do
you
| have any thoughts about what I call plan (b) below, that is:
|
| (b) migrating MSCS to the new domain per kb26196: "How to Move a Windows
| Cluster Server from one domain to another", and then using SQL Server's
Setup
| program, Cluster Administrator, and regedt32 to migrate the instances to
the
| new domain, per kb319016: "How To: Change Domains for a SQL Server 2000
| Failover Cluster"
|
| Would you recommend one approach over another?
|
| "Harvey Hall" wrote:
|
| I need to move a Win2k/SQL2k 2-node cluster to another Domain. I'm
| considering two alternatives: (a) a node by node rebuild to a
Win2k3/SQL2k
| cluster in the new Domain, and (b) migrating MSCS to the new domain per
| kb26196: "How to Move a Windows Cluster Server from one domain to
another",
| and then using SQL Server's Setup program, Cluster Administrator, and
| regedt32 to migrate the instances to the new domain, per per kb319016:
"How
| To: Change Doamins for a SQL Server 2000 Failover Cluster". Any advice?
|
sql

Change

Currently have a 2 node windows 2000 cluster, active/passive, with sql 2000
running a data vault that's controlled by node a. Would like to upgrade to
windows 2003, but run active/active with sql running on node b. To do this,
do I have to reinstall sql server? I'm at a loss and all help and any white
papers would be appreciated.
Thanks in advance.
Hi
Don't think of "active/passive" or "active/active", rather think of it as 2
nodes, with either one or 2 (or 3 or 4 etc) virtual servers.
Currently, you have 2 nodes, with one virtual server and you want to have 2
nodes with 2 virtual servers. Between the 2 nodes, there is a shared quorum
drive.
The virtual server you currently have has a name, an IP address and disk
groups associated with it. If you want an additional virtual server, you
need the same again, another name, another IP address and another set of
disk groups.
Only one node can own a disk group at a time, so it you have allocated all
the space on the SAN to one disk group, you do not have space to make more
virtual disks for the other node. You might need to buy higher capacity
drives, add drives or add another SAN, or reduce the size allocated to the
disk group that currently exists.
I have a strict policy. No OS Upgrades to clusters. Re-Installs only.
Especially if you have to re-do the disk groups, it gives you a chance to
re-do the cluster.
So, backup your databases to a safe place, off the SAN, wipe it, setup your
disks and then re-do the whole cluster.
Get to know the content on
http://www.microsoft.com/windowsserv...g/default.mspx
On the pages, there is a step by step on how to setup a SQL cluster:
http://www.microsoft.com/technet/pro.../failclus.mspx
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:B2FC1873-54BB-40F8-B0BD-CA25597A35E9@.microsoft.com...
> Currently have a 2 node windows 2000 cluster, active/passive, with sql
2000
> running a data vault that's controlled by node a. Would like to upgrade
to
> windows 2003, but run active/active with sql running on node b. To do
this,
> do I have to reinstall sql server? I'm at a loss and all help and any
white
> papers would be appreciated.
> Thanks in advance.
|||I have a slightly different approach. I will allow an OS node upgrade,
mainly to find out compatibility issues, then I go back and rebuild each
node from scratch.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OIoWPIzLFHA.2492@.TK2MSFTNGP14.phx.gbl...
> Hi
> Don't think of "active/passive" or "active/active", rather think of it as
> 2
> nodes, with either one or 2 (or 3 or 4 etc) virtual servers.
> Currently, you have 2 nodes, with one virtual server and you want to have
> 2
> nodes with 2 virtual servers. Between the 2 nodes, there is a shared
> quorum
> drive.
> The virtual server you currently have has a name, an IP address and disk
> groups associated with it. If you want an additional virtual server, you
> need the same again, another name, another IP address and another set of
> disk groups.
> Only one node can own a disk group at a time, so it you have allocated all
> the space on the SAN to one disk group, you do not have space to make more
> virtual disks for the other node. You might need to buy higher capacity
> drives, add drives or add another SAN, or reduce the size allocated to the
> disk group that currently exists.
> I have a strict policy. No OS Upgrades to clusters. Re-Installs only.
> Especially if you have to re-do the disk groups, it gives you a chance to
> re-do the cluster.
> So, backup your databases to a safe place, off the SAN, wipe it, setup
> your
> disks and then re-do the whole cluster.
> Get to know the content on
> http://www.microsoft.com/windowsserv...g/default.mspx
> On the pages, there is a step by step on how to setup a SQL cluster:
> http://www.microsoft.com/technet/pro.../failclus.mspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Scott" <Scott@.discussions.microsoft.com> wrote in message
> news:B2FC1873-54BB-40F8-B0BD-CA25597A35E9@.microsoft.com...
> 2000
> to
> this,
> white
>
|||Thanks Mike and Geoff!!!!
It's pretty much what I figured, but was hoping not.
Again, THANKS!!!!
"Geoff N. Hiten" wrote:

> I have a slightly different approach. I will allow an OS node upgrade,
> mainly to find out compatibility issues, then I go back and rebuild each
> node from scratch.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:OIoWPIzLFHA.2492@.TK2MSFTNGP14.phx.gbl...
>
>

Celko's Netsed Sets vs Adjacency List Models

I am currently modelling a db to store geneaology information (family tree)
Each node on the tree will always have zero, one or two parent nodes,
depending upon whether the details of both parents are known.
I have been initially modelling this using a simple adjacency list model
however I would appreciate any feedback on the advantages and
implementation of a nested set model for this application.
CREATE TABLE persons (
PersonID INT,
MotherID INT,
FatherID INT,
Surname VARCHAR(50),
Firstname VARCHAR(25)
)
In this scenario both the MotherID & FatherID would relate back to PersonID.
Thanks
MurphHi
I'd go with below design
CREATE TABLE Parents
(
[ID] INT NOT NULL PRIMARY KEY,
[NAME]CHAR(1) NOT NULL
)
INSERT INTO Parents VALUES (1,'A')
INSERT INTO Parents VALUES (2,'B')
INSERT INTO Parents VALUES (3,'C')
CREATE TABLE Child
(
[ID] INT NOT NULL PRIMARY KEY,
ParentId INT NOT NULL FOREIGN KEY REFERENCES Parents([ID])ON DELETE
CASCADE ON UPDATE CASCADE,
[NAME]CHAR(2) NOT NULL
)
INSERT INTO F VALUES (1,1,'AA')
INSERT INTO F VALUES (2,1,'AA')
INSERT INTO F VALUES (3,2,'BB')
INSERT INTO F VALUES (4,2,'BB')
INSERT INTO F VALUES (5,2,'BB')
INSERT INTO F VALUES (6,3,'CC')
--OR
CREATE TABLE Persons
(
Child_Id int NOT NULL,
Parentid int NULL,
ChildName varchar(25) NOT NULL,
CONSTRAINT PK_Persons_Childid PRIMARY KEY(Child_Id),
CONSTRAINT FK_Persons_Parentid _Child_Id
FOREIGN KEY(Parentid )
REFERENCES Persons(Child_Id)
)
"Murphy" <m@.urphy.com> wrote in message
news:_jO1e.15253$C7.5562@.news-server.bigpond.net.au...
> I am currently modelling a db to store geneaology information (family
tree)
> Each node on the tree will always have zero, one or two parent nodes,
> depending upon whether the details of both parents are known.
> I have been initially modelling this using a simple adjacency list model
> however I would appreciate any feedback on the advantages and
> implementation of a nested set model for this application.
> CREATE TABLE persons (
> PersonID INT,
> MotherID INT,
> FatherID INT,
> Surname VARCHAR(50),
> Firstname VARCHAR(25)
> )
> In this scenario both the MotherID & FatherID would relate back to
PersonID.
> --
> Thanks
> Murph

CDATA & FOR XML PATH

Hi,
Using a nested FOR XML EXPLICIT statement within an FOR XML PATH query is it
possible to create a node creating cdata?
For example, the statement;
select
pt_description as 'description',
(select 1 as Tag, NULL as Parent, pt_description as [description!1!!cdata]
from property where pt_id = 8957627 for xml explicit, type)
from pt
where pt_id = 9999999
for xml path ('details'), root('info')
Produces;
<info>
<details>
<description>text...</description>
<description>text...</description>
</details>
</info>
Using the nested for xml explicit I was hoping to be able to display the
second description node as;
<description><![CDATA[text...]]></description>
When the 'type' directive is specified it ignores the fact it should contain
cdata.
Am I missing something?...Is this possible to do?
Thanks
Pete
Hi Pete
If you use a FOR XML expression with the TYPE directive, you get an XML
datatype. And the XML datatype (since it is based on the XQuery Datamodel)
does not preserve the CDATA section information.
So the only way to preserve CDATA is by using EXPLICIT mode without TYPE
directive at the top.
Now, I would like to better understand why you want to generate a CDATA
section in the first place. The only impact it has is to allow people to
author certain XML content without having to explicitly entitize characters
such as <, & etc.. Why would that be important during serializing a FOR XML
result?
Thanks
Michael
"Pete Roberts" <peter.roberts@.vebra.com> wrote in message
news:eRrOk2kdFHA.3452@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Using a nested FOR XML EXPLICIT statement within an FOR XML PATH query is
> it possible to create a node creating cdata?
> For example, the statement;
> select
> pt_description as 'description',
> (select 1 as Tag, NULL as Parent, pt_description as [description!1!!cdata]
> from property where pt_id = 8957627 for xml explicit, type)
> from pt
> where pt_id = 9999999
> for xml path ('details'), root('info')
> Produces;
> <info>
> <details>
> <description>text...</description>
> <description>text...</description>
> </details>
> </info>
> Using the nested for xml explicit I was hoping to be able to display the
> second description node as;
> <description><![CDATA[text...]]></description>
> When the 'type' directive is specified it ignores the fact it should
> contain cdata.
> Am I missing something?...Is this possible to do?
> Thanks
> Pete
>
|||Hi Michael,
Thanks for your reply. My belief is that the use of the cdata directive is
necessary as I have html content stored in the database and need to be able
to be rendered as html when producing an xslt transformation. is there an
alternative way that you know of to do this in SQL Server 2005.
When I try using the same statement;
select
pt_description as 'description',
(select 1 as Tag, NULL as Parent, pt_description as [description!1!!cdata]
from property where pt_id = 8957627 for xml explicit)
from pt
where pt_id = 9999999
for xml path ('details'), root('info')
without using the 'TYPE' directive the result displays as follows;
<info>
<details>
<description>text...</description>
<description><![CDATA[text...]]></description>
</details>
</info>
How can I ensure the both the html and the element containing the cdata are
rendered correctly (eg. <element> rather than '<element>...')?...Is
there any alternative way to do this that I'm missing?
Thanks
Pete
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:uxdEMepdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi Pete
> If you use a FOR XML expression with the TYPE directive, you get an XML
> datatype. And the XML datatype (since it is based on the XQuery Datamodel)
> does not preserve the CDATA section information.
> So the only way to preserve CDATA is by using EXPLICIT mode without TYPE
> directive at the top.
> Now, I would like to better understand why you want to generate a CDATA
> section in the first place. The only impact it has is to allow people to
> author certain XML content without having to explicitly entitize
> characters such as <, & etc.. Why would that be important during
> serializing a FOR XML result?
> Thanks
> Michael
> "Pete Roberts" <peter.roberts@.vebra.com> wrote in message
> news:eRrOk2kdFHA.3452@.TK2MSFTNGP10.phx.gbl...
>
|||XSLT should not make a difference between the CDATA section and content that
just had been entitized.
Did you try to take your original output (with the TYPE directive) and pass
it through your XSLT style sheet?
Alternatively, if you need to preserve your CDATA section, you need to use a
top-level EXPLICIT mode query:
select 1 as Tag, NULL as Parent, pt_description as
[details!1!description!element],pt_description as
[details!1!description!cdata]
from property where pt_id = 8957627
for xml explicit, root('info')
Best regards
Michael
"Pete Roberts" <peter.roberts@.vebra.com> wrote in message
news:eHmIDS0dFHA.1612@.tk2msftngp13.phx.gbl...
> Hi Michael,
> Thanks for your reply. My belief is that the use of the cdata directive
> is necessary as I have html content stored in the database and need to be
> able to be rendered as html when producing an xslt transformation. is
> there an alternative way that you know of to do this in SQL Server 2005.
> When I try using the same statement;
> select
> pt_description as 'description',
> (select 1 as Tag, NULL as Parent, pt_description as [description!1!!cdata]
> from property where pt_id = 8957627 for xml explicit)
> from pt
> where pt_id = 9999999
> for xml path ('details'), root('info')
> without using the 'TYPE' directive the result displays as follows;
> <info>
> <details>
> <description>text...</description>
> <description><![CDATA[text...]]></description>
> </details>
> </info>
> How can I ensure the both the html and the element containing the cdata
> are rendered correctly (eg. <element> rather than
> '<element>...')?...Is there any alternative way to do this that I'm
> missing?
> Thanks
> Pete
>
> "Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
> news:uxdEMepdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>