asked
SQL Clustering
I have 2 versions of sql one is 2005 and other is 2008 is it possible to sql clustering if yes then how ?
You have some answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
If I understand correctly Can you mix versions of SQL on a cluster? Yes How? Use named instances. Create your cluster, setup the drives etc Pick which to install as a named instance (or both) Then install as you require
You can run both 2005 and 2008 versions on each node of a cluster, but you cannot failover between versions. Picture this scenario: Server A is the active cluster node for 2 instances: SQL2005 and SQL2008 Server B is a failover node for both instances. If Server A fails, the SQL2005 instance would failover to Server B, and the same would happen with the 2008 instances. But you must configure the clustering for each instance, and both servers will need to be configured for both instances (using the respective versions). I hope that answers your question.
There's not two instances per node, two installs for each (4 installs total) but not instances. Each version will only have one instance
And that is the danger of trying to help before coffee. :) You are correct. I need to go now, but I will fix my answer when I get to work. I was trying to say that each server will have both versions of SQL Server, but I didn't explain it correctly. The main point is that you can't failover across versions.
20 People are following this question.
