We help IT Professionals succeed at work.
Get Started

How to migrate SQL 2012 Cluster to new SAN storage without down time?

708 Views
Last Modified: 2016-06-24
We have a 2 node SQL cluster (Vmware 6.0,  Windows 2012, SQL 2012) in an active/Passive model.  Both nodes currently connect via iscsi (through windows iscsi initiator) to shared LUNs on a equallogic SAN.

We are replacing the aging equallogic with a new Compellent SAN.

Are there any articles/KB/discussions out there on how to do a migration of the shared iscsi sql disks to a new iscsi SAN with minimal (or better, zero) down time?

The SQL DB's host our main web site and we can't afford to have much down time (anything more than a couple of minutes is too much).  

Anyone have any recommendations/experienceon how to get this done?

We can do the OS/Swap disks via vmware storage vmotion as they are VMDK's.  but the data/log disks for sql are shared iscsi luns on the SAN and equallogic doesn't talk to Compellent so we can't do a copy directly.


Thanks
Comment
Watch Question
Scott PletcherSenior DBA
CERTIFIED EXPERT
Most Valuable Expert 2018
Distinguished Expert 2019
Commented:
This problem has been solved!
Unlock 2 Answers and 12 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE