MS Clustered database server storage migration with RDM disks mounted

I have a microsoft database server cluster composed of two nodes. Each node have three shared rdm disks mounted as shared disks.

Now, we are replacing the old storage device where these shared disks reside on. when I tried to migrate the vm with the storage, it gave me error message as showed below:


How could I migrate these shared rdm disks from old SAN to new SAN without rebuild these MS SQL servers.

Thanks.
storage-migration-error.png
Jason YuAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark ElySenior Coldfusion DeveloperCommented:
Your SCSI comptroller is not set to share the virtual disks.  To resolve this either set the 'SCSI Bus Sharing' type to either 'None' or 'Virutal'.  Your VM will need to be powered down before you can make a change.
Mark ElySenior Coldfusion DeveloperCommented:
BTW:

None – the virtual disks won’t be shared with other VMs.
Virtual – the virtual disks can be shared with other VMs on the same host.
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Is this Cluster in a Box ?

e.g. two VMs sharing the same VMDK on a single host?
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Paul SolovyovskySenior IT AdvisorCommented:
@Mark

MS Clustering does not support virtual RDMs.  Best way to do this is move the databases and quorum to different RDMs mounted from the new SAN.  These are essentially LUNs on a SAN that have a pointer vmdk file on them.  This is typically a forklift upgrade.

What type of storage are you using?
Jason YuAuthor Commented:
Yes, both vms are on the same host.
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Are you sure you are using RDMs?

and this is not Clustered Sharing of VMDKs, because this should not really be used in production, and the error you are observing is to be expected.

So can you check the disk properties, and confirm, these are VMDKs ?
Paul SolovyovskySenior IT AdvisorCommented:
cluster in a box is never a god option for production
Jason YuAuthor Commented:
the old storage is netapp 3250

the new one are 8040 with cluster ontop 8.2.3. we plan to update it to 8.3 pretty soon next month.

We have done the storage migration with RDMs for oracle platform, but not yet for MS SQL cluster.

Mark and Paulsolov, could you advise the best method to do it. If we need export database and reinstall another two vms, that will involve lots of changes from application sides.
Paul SolovyovskySenior IT AdvisorCommented:
I feel your pain..but yours should be easier since you're running 8.2 or higher 7 mode on the 3250 most likely

You should be able to snapmirror and reconnect, you may need to ensure that volume IDs are the same.

Another method is to use Snapmanager for SQL and migrate the volumes to the new LUNs (quorum will need to be manual)

On another note you can run non MS Clustered SQL servers on Netapp datastores and still leverage SMSQL
Jason YuAuthor Commented:
I talked to our lead engineer just now, he asked me to set up a test environment to test all possible solutions.

Is snapmirror a build in feature of Ontap system manager of netapp?

I will test snapmirror first, then try the other one which is backup database and restore it back.

Only these two methods?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Is snapmirror a build in feature of Ontap system manager of netapp?

if you have a license for it!
Paul SolovyovskySenior IT AdvisorCommented:
If not you can ask for evaluation copy since you're migrating from Netapp to Netapp
Paul SolovyovskySenior IT AdvisorCommented:
BTW, it's easier to migrate if you're on 8.2.3 (still handles 32 bit aggregate migration) vs 8.3 which doesn't
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage

From novice to tech pro — start learning today.