March 2, 2011 at 12:41 pm
Is it possible to have sql server 2005 coexist with 2008 on a cluster? If yes, do I install 2008 and then install 2005 as another instance? What issues will we possibly see with this? Thanks!
March 2, 2011 at 12:45 pm
why would you do this? I would think you would just change the compatibility of the database that needs SQL 2005 to SQL 2005.
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
March 2, 2011 at 1:00 pm
One reason to do this is to have tempdb in different compatibility. If you have a user database in 2005 compatibility on a 2008 instance any code using tempdb will be run in the tempdb's compatibility mode, which would be 2008. Might cause issues, might not.
There are no issues having a 2005 and 2008 instance on same server. I cannot comment on cluster as I have not attempted that type of setup but I cannot think of any reason why it would not work. You would just need to be aware that any shared resources would most likely be 2008.
March 2, 2011 at 1:12 pm
Yes the vendor was very adamant about keeping the versions separate. So would I install 2008 and then an instance of 2005?
March 2, 2011 at 1:32 pm
Should I choose a different folder for the components install rather than the default?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply