Re: Multiple SQL Clusters on one EMC LUN?

Giganews Newsgroups
Subject: Re: Multiple SQL Clusters on one EMC LUN?
Posted by:  Anthony Thomas (ALThom…
Date: Wed, 7 Feb 2007

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


Anthony Thomas


"Andrew Williams" <andrew.willia…> wrote in message
> 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
> 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
> 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



In response to

Multiple SQL Clusters on one EMC LUN? posted by Andrew Williams on Wed, 7 Feb 2007