Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBAMike
Starting Member
2 Posts |
 Posted - 2006-04-20 : 19:00:18
|
| Can multiple SQL instances (sql server 2000 and sql server 2005) be clustered in an active/active environment?Thank you. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-21 : 14:37:05
|
| One of the DBAs here sent an e-mail to MS asking the same thing. The answer was yes.Tara Kizeraka tduggan |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-04-21 : 14:57:54
|
| I don't know about you guys, but I think I'd make a call to PSS to make that install happen :)Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
DBAMike
Starting Member
2 Posts |
Posted - 2006-04-21 : 16:08:02
|
| I hope I was clear earlier in my question. We want to cluster both versions of SQL Server in the same active/active cluster.Thank you. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-21 : 16:12:32
|
| Yes. That is what I answered.Tara Kizeraka tduggan |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-22 : 00:26:37
|
| test--------------------keeping it simple... |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-04-22 : 18:15:37
|
| EyeChart seems to disagree...http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65096Something tells me it can be done, but it has to be done in a very special way.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-04-23 : 00:04:01
|
quote:
Originally posted by tkizer
One of the DBAs here sent an e-mail to MS asking the same thing. The answer was yes.Tara Kizeraka tduggan
tara, I think we got bad info from our ms reps. I have spent the better part of two days trying to fix on of our dev/test clusters.Maybe the problem is because of our environment, but we are running 64bit windows 2003 sp1 (x64), with several 32 bit sql 2000 SP4+ virtual hosts. Adding a 64bit SQL2k5 to that mix has completely and totally jacked the system up. It is unreal how screwed this system is now.I would just recommend, that what ever you do, do not install 2k5 on a production system without having tested the same exact scenario on a dev/test environment. You have been warned..-ec |
|
|
|
|
|
|
|
|
Cluster sql server 2000 and sql server 2005?