April 23, 2009 at 8:50 am
Hi everyone
I am after a bit of guidance...
We are currently running a active\passive Windows Server 2003 cluster with SS2K as the default instance. The cluster has various RAID arrays through DAS and the disk capacity is fully utilised and owned under the SQLCluster group in Cluster Admin.
We are looking to add a SS2008 named instance to this environment which would enable us run a side by side upgrade of various databases to SS2008 over period of time. An in place upgrade is not feasible.
The question is can both instances be owners of the same disk resources? I can remember reading somewhere that this is not good and causes issues but cannot find my bookmark to the documentation 🙁
We would manage things so the active node always has both instances and therefore ownership of the available RAID arrays.
Am i correct in thinking multiple instances sharing disk resources is a bad thing?
Any advice would be very gratefully received!!!
Regards
KG
April 23, 2009 at 10:44 am
No this isn't possible. Each instance requires its own disks on the cluster.
Another issue you'll find is that I don't believe that you can install SQL 2000 and SQL 2008 on the same machine side by side. (Granted the last time I tried was during beta, so I'm not 100% on this point; but you'll want to test this first.)
April 24, 2009 at 2:00 am
Thank you. That confirms my thoughts.
We've got 2K Dev edition and 2008 Dev edition running side by side on our Dev box. With 2k being the default instance and 2008 a named instance. We have encountered no problems so far.
Regards
KG
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply