Multiple SQL Clusters on one EMC LUN?

Hello,
We have a Production SQL 2000 Cluster and are now developing on SQL 2K5 as
we plan to migrate shortly. We'll be introducing new hardware into
production with 2K5 installed. We would like to use a 'straddle migration'
method by utilizing both 2K and 2K5 in production at the same time and
moving services/websites/databases to 2K5 one at a time in case there are
any issues and we need to roll back over to 2K.
The question is how can we utilize the current LUNs/Cluster that's on the
EMC for the new 2K5 servers/cluster? Can we have a 2K and 2K5 cluster using
the same LUN? How would the Q: Quarum drive work? What possible
complications do see in this scenario?
Thank you in advance for your time,
Andew
If you do side by side, then you cannot use the same virtual server name,
instance name, IP address, or network port. Moreover, you will have to have
an independent dedicated disk(s) for the installation to even succeed.
Afterwards, however, you can use either detach/attach or database backups
and restores to migrate from one instance the next. If a rollback is called
for, you only have to point the connections back to the SS2K instance and
you're off and running again.
If your upgrade is successful, then you just uninstall the SS2K instance and
give storage back their original LUN for reuse.
What we typically do is restore pending the prior day's full database
backup, and then kick off a differential right before the migration. This
keeps the backup, transfer, restore window small during the migration
outage.
Sincerely,
Anthony Thomas

"Andrew Williams" <andrew.williams@.freedompay.com> wrote in message
news:99A9028F-DB5C-4E5F-9320-8BCA23F0C2B7@.microsoft.com...
> Hello,
> We have a Production SQL 2000 Cluster and are now developing on SQL 2K5 as
> we plan to migrate shortly. We'll be introducing new hardware into
> production with 2K5 installed. We would like to use a 'straddle
migration'
> method by utilizing both 2K and 2K5 in production at the same time and
> moving services/websites/databases to 2K5 one at a time in case there are
> any issues and we need to roll back over to 2K.
> The question is how can we utilize the current LUNs/Cluster that's on the
> EMC for the new 2K5 servers/cluster? Can we have a 2K and 2K5 cluster
using
> the same LUN? How would the Q: Quarum drive work? What possible
> complications do see in this scenario?
> Thank you in advance for your time,
>
> Andew
>
|||> Can we have a 2K and 2K5 cluster using
> the same LUN?
(assuming with LUN you mean physical disk resource in the cluster)
No, they need to be in there own dedicated cluster group with dedicated
physical disk resources

> How would the Q: Quarum drive work?
Quorum disk should be, together with cluster IP and cluster name and
possibly MSDTC, in it own cluster group, this is the *default* setup. No
changes for the Quorum disk
So you end up with:
cluster group - cluster resources (including Quorum disk)
group1 - SQL2K (with its own dedicated disks, IP, network name)
group2 - SQL2K5 (with its own dedicated disks, IP, network name)
does this answer your question ?
rgds,
edwin.