August 4, 2006 at 10:47 am
Is there anyone here experience to have SQL 2000 in one instance and SQL2005 in other instance in the same box in a clustered environment?
If yes, are there any issues?
August 4, 2006 at 3:35 pm
Yes, That defeats the whole purpose of clustering. If the machine with the two instances has a hardware failure. Your whole cluster fails. Where if you had two seperate physical machines with their own install of SQL Server, then in the case of a hardware failure the MSCS would fail over to the other server.
August 4, 2006 at 5:21 pm
Clarify:
Two instances in one box with two different version of SQL Server. It is a Active/Passive environment.
If there is a hardware failure. The other box kicks in...
August 6, 2006 at 7:59 pm
As far as I know, there should be no issues.
Only thing I am aware of is that you cannot install another SQL 2000 after installing SQL 2005 instance. I remember there is workaround from Microsoft for this.
August 7, 2006 at 9:15 am
It should be possible but I figure it would be horrible to support, a failover in one instance would force a failover of the other I figure - could be messy!!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
August 8, 2006 at 11:12 am
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_9i5u.asp
You can run only one instance of SQL Server on each virtual server of a SQL Server failover cluster, although you can install up to 16 virtual servers on a failover cluster. The instance can be either a default instance or a named instance.
This means it is not advisable?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply