dbTalk Databases Forums  

SQL Clustering - two clusters, same LAN

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SQL Clustering - two clusters, same LAN in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
apatel4000
 
Posts: n/a

Default SQL Clustering - two clusters, same LAN - 09-08-2008 , 08:43 AM






Hi

I'm new to SQL server so i'm hoping that some of you pros out there can help
me out. We are looking to perform an upgrade on our SQL clusters. Fortunately
enough we have two sets of hardware so this probably makes life a little
easier in that the existing cluster will remain untouched.

Spec:-

Existing Cluster: SQL Server 2000/Win2k3 Ent
New Cluster: SQL Server 2005/Win2K3 Ent
**Both clusters are attached to two separate storage devices.

We effectively want one cluster active, and second offline. We hope that
this will give us the ability to switch back in the event if the new cluster
causes problems. Both clusters will be connected to the same network but
will remain in a active/passive state so to speak.

To aid with the migration can we bring one cluster down and bring the new one
up? Not sure if that’s possible and what potential problems this would cause
hence why i'm here asking for advice.

I'd be grateful if anybody can shed any light or advise on what the best
approach would be in this case? Ideally if things don't go according to plan,
we want to be in a position where we can revert back to the old (SQL 2000)
cluster. The SQL named instances would need to remain the same on the new
cluster due to external applications that rely on these named instances.

Hope that makes sense......


Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL Clustering - two clusters, same LAN - 09-08-2008 , 10:34 AM






You can use a new set of names for the new SQL Server Instances. Simply set
up a DNS alias that points the old names to the new servers. Add or remove
the alias when you activate or deactivate the old cluster.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP





"apatel4000" <u46052@uwe> wrote

Quote:
Hi

I'm new to SQL server so i'm hoping that some of you pros out there can
help
me out. We are looking to perform an upgrade on our SQL clusters.
Fortunately
enough we have two sets of hardware so this probably makes life a little
easier in that the existing cluster will remain untouched.

Spec:-

Existing Cluster: SQL Server 2000/Win2k3 Ent
New Cluster: SQL Server 2005/Win2K3 Ent
**Both clusters are attached to two separate storage devices.

We effectively want one cluster active, and second offline. We hope that
this will give us the ability to switch back in the event if the new
cluster
causes problems. Both clusters will be connected to the same network but
will remain in a active/passive state so to speak.

To aid with the migration can we bring one cluster down and bring the new
one
up? Not sure if that’s possible and what potential problems this would
cause
hence why i'm here asking for advice.

I'd be grateful if anybody can shed any light or advise on what the best
approach would be in this case? Ideally if things don't go according to
plan,
we want to be in a position where we can revert back to the old (SQL 2000)
cluster. The SQL named instances would need to remain the same on the new
cluster due to external applications that rely on these named instances.

Hope that makes sense......



Reply With Quote
  #3  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL Clustering - two clusters, same LAN - 09-08-2008 , 10:34 AM



You can use a new set of names for the new SQL Server Instances. Simply set
up a DNS alias that points the old names to the new servers. Add or remove
the alias when you activate or deactivate the old cluster.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP





"apatel4000" <u46052@uwe> wrote

Quote:
Hi

I'm new to SQL server so i'm hoping that some of you pros out there can
help
me out. We are looking to perform an upgrade on our SQL clusters.
Fortunately
enough we have two sets of hardware so this probably makes life a little
easier in that the existing cluster will remain untouched.

Spec:-

Existing Cluster: SQL Server 2000/Win2k3 Ent
New Cluster: SQL Server 2005/Win2K3 Ent
**Both clusters are attached to two separate storage devices.

We effectively want one cluster active, and second offline. We hope that
this will give us the ability to switch back in the event if the new
cluster
causes problems. Both clusters will be connected to the same network but
will remain in a active/passive state so to speak.

To aid with the migration can we bring one cluster down and bring the new
one
up? Not sure if that’s possible and what potential problems this would
cause
hence why i'm here asking for advice.

I'd be grateful if anybody can shed any light or advise on what the best
approach would be in this case? Ideally if things don't go according to
plan,
we want to be in a position where we can revert back to the old (SQL 2000)
cluster. The SQL named instances would need to remain the same on the new
cluster due to external applications that rely on these named instances.

Hope that makes sense......



Reply With Quote
  #4  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL Clustering - two clusters, same LAN - 09-08-2008 , 10:34 AM



You can use a new set of names for the new SQL Server Instances. Simply set
up a DNS alias that points the old names to the new servers. Add or remove
the alias when you activate or deactivate the old cluster.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP





"apatel4000" <u46052@uwe> wrote

Quote:
Hi

I'm new to SQL server so i'm hoping that some of you pros out there can
help
me out. We are looking to perform an upgrade on our SQL clusters.
Fortunately
enough we have two sets of hardware so this probably makes life a little
easier in that the existing cluster will remain untouched.

Spec:-

Existing Cluster: SQL Server 2000/Win2k3 Ent
New Cluster: SQL Server 2005/Win2K3 Ent
**Both clusters are attached to two separate storage devices.

We effectively want one cluster active, and second offline. We hope that
this will give us the ability to switch back in the event if the new
cluster
causes problems. Both clusters will be connected to the same network but
will remain in a active/passive state so to speak.

To aid with the migration can we bring one cluster down and bring the new
one
up? Not sure if that’s possible and what potential problems this would
cause
hence why i'm here asking for advice.

I'd be grateful if anybody can shed any light or advise on what the best
approach would be in this case? Ideally if things don't go according to
plan,
we want to be in a position where we can revert back to the old (SQL 2000)
cluster. The SQL named instances would need to remain the same on the new
cluster due to external applications that rely on these named instances.

Hope that makes sense......



Reply With Quote
  #5  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL Clustering - two clusters, same LAN - 09-08-2008 , 10:34 AM



You can use a new set of names for the new SQL Server Instances. Simply set
up a DNS alias that points the old names to the new servers. Add or remove
the alias when you activate or deactivate the old cluster.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP





"apatel4000" <u46052@uwe> wrote

Quote:
Hi

I'm new to SQL server so i'm hoping that some of you pros out there can
help
me out. We are looking to perform an upgrade on our SQL clusters.
Fortunately
enough we have two sets of hardware so this probably makes life a little
easier in that the existing cluster will remain untouched.

Spec:-

Existing Cluster: SQL Server 2000/Win2k3 Ent
New Cluster: SQL Server 2005/Win2K3 Ent
**Both clusters are attached to two separate storage devices.

We effectively want one cluster active, and second offline. We hope that
this will give us the ability to switch back in the event if the new
cluster
causes problems. Both clusters will be connected to the same network but
will remain in a active/passive state so to speak.

To aid with the migration can we bring one cluster down and bring the new
one
up? Not sure if that’s possible and what potential problems this would
cause
hence why i'm here asking for advice.

I'd be grateful if anybody can shed any light or advise on what the best
approach would be in this case? Ideally if things don't go according to
plan,
we want to be in a position where we can revert back to the old (SQL 2000)
cluster. The SQL named instances would need to remain the same on the new
cluster due to external applications that rely on these named instances.

Hope that makes sense......



Reply With Quote
  #6  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL Clustering - two clusters, same LAN - 09-08-2008 , 10:34 AM



You can use a new set of names for the new SQL Server Instances. Simply set
up a DNS alias that points the old names to the new servers. Add or remove
the alias when you activate or deactivate the old cluster.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP





"apatel4000" <u46052@uwe> wrote

Quote:
Hi

I'm new to SQL server so i'm hoping that some of you pros out there can
help
me out. We are looking to perform an upgrade on our SQL clusters.
Fortunately
enough we have two sets of hardware so this probably makes life a little
easier in that the existing cluster will remain untouched.

Spec:-

Existing Cluster: SQL Server 2000/Win2k3 Ent
New Cluster: SQL Server 2005/Win2K3 Ent
**Both clusters are attached to two separate storage devices.

We effectively want one cluster active, and second offline. We hope that
this will give us the ability to switch back in the event if the new
cluster
causes problems. Both clusters will be connected to the same network but
will remain in a active/passive state so to speak.

To aid with the migration can we bring one cluster down and bring the new
one
up? Not sure if that’s possible and what potential problems this would
cause
hence why i'm here asking for advice.

I'd be grateful if anybody can shed any light or advise on what the best
approach would be in this case? Ideally if things don't go according to
plan,
we want to be in a position where we can revert back to the old (SQL 2000)
cluster. The SQL named instances would need to remain the same on the new
cluster due to external applications that rely on these named instances.

Hope that makes sense......



Reply With Quote
  #7  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL Clustering - two clusters, same LAN - 09-08-2008 , 10:34 AM



You can use a new set of names for the new SQL Server Instances. Simply set
up a DNS alias that points the old names to the new servers. Add or remove
the alias when you activate or deactivate the old cluster.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP





"apatel4000" <u46052@uwe> wrote

Quote:
Hi

I'm new to SQL server so i'm hoping that some of you pros out there can
help
me out. We are looking to perform an upgrade on our SQL clusters.
Fortunately
enough we have two sets of hardware so this probably makes life a little
easier in that the existing cluster will remain untouched.

Spec:-

Existing Cluster: SQL Server 2000/Win2k3 Ent
New Cluster: SQL Server 2005/Win2K3 Ent
**Both clusters are attached to two separate storage devices.

We effectively want one cluster active, and second offline. We hope that
this will give us the ability to switch back in the event if the new
cluster
causes problems. Both clusters will be connected to the same network but
will remain in a active/passive state so to speak.

To aid with the migration can we bring one cluster down and bring the new
one
up? Not sure if that’s possible and what potential problems this would
cause
hence why i'm here asking for advice.

I'd be grateful if anybody can shed any light or advise on what the best
approach would be in this case? Ideally if things don't go according to
plan,
we want to be in a position where we can revert back to the old (SQL 2000)
cluster. The SQL named instances would need to remain the same on the new
cluster due to external applications that rely on these named instances.

Hope that makes sense......



Reply With Quote
  #8  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL Clustering - two clusters, same LAN - 09-08-2008 , 10:34 AM



You can use a new set of names for the new SQL Server Instances. Simply set
up a DNS alias that points the old names to the new servers. Add or remove
the alias when you activate or deactivate the old cluster.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP





"apatel4000" <u46052@uwe> wrote

Quote:
Hi

I'm new to SQL server so i'm hoping that some of you pros out there can
help
me out. We are looking to perform an upgrade on our SQL clusters.
Fortunately
enough we have two sets of hardware so this probably makes life a little
easier in that the existing cluster will remain untouched.

Spec:-

Existing Cluster: SQL Server 2000/Win2k3 Ent
New Cluster: SQL Server 2005/Win2K3 Ent
**Both clusters are attached to two separate storage devices.

We effectively want one cluster active, and second offline. We hope that
this will give us the ability to switch back in the event if the new
cluster
causes problems. Both clusters will be connected to the same network but
will remain in a active/passive state so to speak.

To aid with the migration can we bring one cluster down and bring the new
one
up? Not sure if that’s possible and what potential problems this would
cause
hence why i'm here asking for advice.

I'd be grateful if anybody can shed any light or advise on what the best
approach would be in this case? Ideally if things don't go according to
plan,
we want to be in a position where we can revert back to the old (SQL 2000)
cluster. The SQL named instances would need to remain the same on the new
cluster due to external applications that rely on these named instances.

Hope that makes sense......



Reply With Quote
  #9  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL Clustering - two clusters, same LAN - 09-08-2008 , 10:34 AM



You can use a new set of names for the new SQL Server Instances. Simply set
up a DNS alias that points the old names to the new servers. Add or remove
the alias when you activate or deactivate the old cluster.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP





"apatel4000" <u46052@uwe> wrote

Quote:
Hi

I'm new to SQL server so i'm hoping that some of you pros out there can
help
me out. We are looking to perform an upgrade on our SQL clusters.
Fortunately
enough we have two sets of hardware so this probably makes life a little
easier in that the existing cluster will remain untouched.

Spec:-

Existing Cluster: SQL Server 2000/Win2k3 Ent
New Cluster: SQL Server 2005/Win2K3 Ent
**Both clusters are attached to two separate storage devices.

We effectively want one cluster active, and second offline. We hope that
this will give us the ability to switch back in the event if the new
cluster
causes problems. Both clusters will be connected to the same network but
will remain in a active/passive state so to speak.

To aid with the migration can we bring one cluster down and bring the new
one
up? Not sure if that’s possible and what potential problems this would
cause
hence why i'm here asking for advice.

I'd be grateful if anybody can shed any light or advise on what the best
approach would be in this case? Ideally if things don't go according to
plan,
we want to be in a position where we can revert back to the old (SQL 2000)
cluster. The SQL named instances would need to remain the same on the new
cluster due to external applications that rely on these named instances.

Hope that makes sense......



Reply With Quote
  #10  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL Clustering - two clusters, same LAN - 09-08-2008 , 10:34 AM



You can use a new set of names for the new SQL Server Instances. Simply set
up a DNS alias that points the old names to the new servers. Add or remove
the alias when you activate or deactivate the old cluster.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP





"apatel4000" <u46052@uwe> wrote

Quote:
Hi

I'm new to SQL server so i'm hoping that some of you pros out there can
help
me out. We are looking to perform an upgrade on our SQL clusters.
Fortunately
enough we have two sets of hardware so this probably makes life a little
easier in that the existing cluster will remain untouched.

Spec:-

Existing Cluster: SQL Server 2000/Win2k3 Ent
New Cluster: SQL Server 2005/Win2K3 Ent
**Both clusters are attached to two separate storage devices.

We effectively want one cluster active, and second offline. We hope that
this will give us the ability to switch back in the event if the new
cluster
causes problems. Both clusters will be connected to the same network but
will remain in a active/passive state so to speak.

To aid with the migration can we bring one cluster down and bring the new
one
up? Not sure if that’s possible and what potential problems this would
cause
hence why i'm here asking for advice.

I'd be grateful if anybody can shed any light or advise on what the best
approach would be in this case? Ideally if things don't go according to
plan,
we want to be in a position where we can revert back to the old (SQL 2000)
cluster. The SQL named instances would need to remain the same on the new
cluster due to external applications that rely on these named instances.

Hope that makes sense......



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.