<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 High Availability
»
Running SQL 2005 & 2008 in a 2 node cluster
11 posts, Page 1 of 2
1
2
»»
Running SQL 2005 & 2008 in a 2 node cluster
Rate Topic
Display Mode
Topic Options
Author
Message
pwillemsen
pwillemsen
Posted Tuesday, October 09, 2012 8:22 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, October 10, 2012 10:58 PM
Points: 3,
Visits: 6
Is it possible to have a setup running SQL 2005 & 2008 in a 2 node cluster?
Thanks
Pete
Post #1370651
mahesh.dasoni
mahesh.dasoni
Posted Tuesday, October 09, 2012 10:26 PM
SSC Journeyman
Group: General Forum Members
Last Login: 2 days ago @ 7:26 AM
Points: 81,
Visits: 860
It is possible to run SQL Server 2005 and 2008 instance on Two Node Cluster.
Post #1370667
pwillemsen
pwillemsen
Posted Tuesday, October 09, 2012 11:57 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, October 10, 2012 10:58 PM
Points: 3,
Visits: 6
Maybe I should have been a bit more specific. If it is possible, is there a "best practise" to do this. Can we still use a passive / active setup or would we be better of using passive / passive?
What I was thinking about is have a 2 node cluster setup where server A has an active SQL 2008 instance and a passive 2005 instance.
Server B would have an active 2005 instance and a passive 2008. This way both servers would be utilised properly during normal operations. Only when a server falls over, the other server has to bear the load of 2 active instances.
Not sure if something like this is doable or - just as important - manageable.
Thanks.
Post #1370690
Perry Whittle
Perry Whittle
Posted Wednesday, October 10, 2012 1:17 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:15 PM
Points: 5,204,
Visits: 11,162
pwillemsen (10/9/2012)
Maybe I should have been a bit more specific. If it is possible, is there a "best practise" to do this. Can we still use a passive / active setup or would we be better of using passive / passive?
What I was thinking about is have a 2 node cluster setup where server A has an active SQL 2008 instance and a passive 2005 instance.
Server B would have an active 2005 instance and a passive 2008. This way both servers would be utilised properly during normal operations. Only when a server falls over, the other server has to bear the load of 2 active instances.
Not sure if something like this is doable or - just as important - manageable.
Thanks.
Windows 2008 or 2008 R2?
What Service pack level?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Post #1370729
pwillemsen
pwillemsen
Posted Wednesday, October 10, 2012 5:19 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, October 10, 2012 10:58 PM
Points: 3,
Visits: 6
That would be on 2 servers running Windows 2008 R2 SP1.
Post #1371163
Vegard Hagen
Vegard Hagen
Posted Monday, October 15, 2012 12:20 AM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 5:18 AM
Points: 494,
Visits: 326
Sounds fairly straight forward to me.
Basically, each SQL Server instance is set up as a separate installation and should not interfere with other instances as long as you have enough system resources to keep everybody happy. I don't see any problems here as long as you keep in mind that the new features in 2008 won't be available when working with the 2005 instance.
Vegard Hagen
Norwegian DBA, blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegard's corner
(No actual SQL stuff here - haven't found my niche yet. Maybe some day...)
"It is better to light a candle than to curse the darkness."
(Chinese proverb)
Post #1372568
ambesh.bharadwaj
ambesh.bharadwaj
Posted Tuesday, October 16, 2012 4:13 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, November 26, 2012 3:07 AM
Points: 3,
Visits: 37
only problem will occur when you are testing failover since all of the new features of 2008 instance will not be available and you may face issue with jobs and alerts and also your log backup strategy should be changed while switching.
Post #1373108
SQL Show
SQL Show
Posted Wednesday, October 17, 2012 5:44 AM
Old Hand
Group: General Forum Members
Last Login: Today @ 3:36 AM
Points: 305,
Visits: 493
[I don't see any problems here as long as you keep in mind that the new features in 2008 won't be available when working with the 2005 instance.
[/quote]]
Hagen, Can you please explain a bit more of what could be the problem.
Post #1373737
Vegard Hagen
Vegard Hagen
Posted Wednesday, October 17, 2012 5:50 AM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 5:18 AM
Points: 494,
Visits: 326
ambesh.bharadwaj (10/16/2012)
only problem will occur when you are testing failover since all of the new features of 2008 instance will not be available and you may face issue with jobs and alerts and also your log backup strategy should be changed while switching.
Actually, that is not true because both instances would be installed on both cluster nodes, only running on one at a time. So, when the 2008 instance fails over, it will still be the 2008 instance with all the 2008 features, only running on a different physical node.
Vegard Hagen
Norwegian DBA, blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegard's corner
(No actual SQL stuff here - haven't found my niche yet. Maybe some day...)
"It is better to light a candle than to curse the darkness."
(Chinese proverb)
Post #1373739
Vegard Hagen
Vegard Hagen
Posted Wednesday, October 17, 2012 5:55 AM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 5:18 AM
Points: 494,
Visits: 326
dbasql79 (10/17/2012)
[Hagen, Can you please explain a bit more of what could be the problem.
It's not necessarily a problem, just something you'll need to be aware of.
Each new version has its new features and slightly modified ways of doing things. I imagine you would be using the 2008 version of SQL Server Management Studio to connect to both instances, since... well, basically because you can and why use two different tools when one will work for both cases? I was just saying that you need to be aware of the fact that 2008 features will not be available for the 2005 instance, even if you use 2008 client tools to connect to it.
Vegard Hagen
Norwegian DBA, blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegard's corner
(No actual SQL stuff here - haven't found my niche yet. Maybe some day...)
"It is better to light a candle than to curse the darkness."
(Chinese proverb)
Post #1373741
« Prev Topic
|
Next Topic »
11 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
