Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / December 2005

Tip: Looking for answers? Try searching our database.

Clustering different versions of SQL Serv 2005

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
divensail - 28 Dec 2005 15:13 GMT
Is it possible to have different versions of SQL Server 2005 clustered as
various nodes. ie:

Node 1 - Sql server 2005 Enterprise
Node 2 - Sql server 2005 Standard
Node 3 - Sql server 2005 Standard
Geoff N. Hiten - 28 Dec 2005 15:27 GMT
You have a slight misunderstanding of how clustering works.

In a clustered environment, there are SQL instances and host nodes.  The two
entities are entirely independent.  An Instance can run on one or more
nodes.  A node can host zero or more instances at any given time.
Generally, I set up clusters with each instance on a preferred node, just so
I can find it easily.  So, what you are looking for is a cluster with three
nodes and three SQL instances, each instance normally running on a separate
node.  In addition, the instances may be different editions of the SQL
Server product.

Since instances are independent of each other as well as the host nodes, you
can mix and match versions and editions on the same cluster, just like on a
stand-alone system.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Is it possible to have different versions of SQL Server 2005 clustered as
> various nodes. ie:
>
> Node 1 - Sql server 2005 Enterprise
> Node 2 - Sql server 2005 Standard
> Node 3 - Sql server 2005 Standard
Mike Epprecht (SQL MVP) - 28 Dec 2005 17:34 GMT
Hi

Just to add to Geoff's comments.

Since you have 3 nodes, Standard Edition will not install on all 3 as it
supports 2 node clusters only.

So you have to pick the possible owner nodes very carefully.

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/

> Is it possible to have different versions of SQL Server 2005 clustered as
> various nodes. ie:
>
> Node 1 - Sql server 2005 Enterprise
> Node 2 - Sql server 2005 Standard
> Node 3 - Sql server 2005 Standard
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.