I have 2 SQL servers, both are 2014, that were setup by another person and I need a little help with understanding the setup.
They are set up with Failover Cluster Manager and both servers appear as nodes and are up.
The storage disks are currently owned by one of the servers and all are online (Data, Witness & DTC).
Both are VM's in a VMware setup.
I have 3 MD3000i storage drives (2 old and 1 new). I am retiring one of the old drives and putting the new one in service.
Everything is working fine but I need to move both of the SQL Servers from datastore 1 to datastore 2. I am concerned about data loss and vCenter going down as it is also running on these SQL servers.
I am getting the error "Device SCSI controller 1 is a SCSI controller engaged in bus-sharing" when I try to migrate with them turned on. So I need to turn one off, migrate it, turn it on, check that it is the owner of the data drives then turn off the other and migrate it.
Both SQL VM's are on datastore 1 and SQL data is on datastore 2.
I started looking at the two VM's to see if any settings were different that might throw a wrench in this plan and noticed a couple of oddities:
1) SQL server 2 is current Owner but when reviewing the VM info in Datastore 1 SQL server 2 is not using any drive space, SQL server 1 is using 41GB. SQL server 2 also appears in Datastore 2 and is using 41GB.
Is this normal? I know the data is sitting on Datastore 2.
2) The mapped drives appear in SQL server 2 windows explorer but not in SQL server 1 windows explorer. Since SQL server 2 is current owner this is correct. But if SQL server 2 goes down SQL server 1 will become owner and the mapped drives will move. Correct?
3) When I view the summary of the VM through the Hosts and Cluster view, both SQL servers show they are using datastore 1 (the one I am retiring) and SQL 2 also shows using datastore 2. But when I browse the datastore 1 from there I only see SQL server 1, no SQL server 2. When I browse the datastore 1 from "Datastores and Datastores Clusters" both SQL 1 & 2 appear in Datastore 1. And SQL 2 also appears in Datastore 2. Normal?
So it looks like vCenter holds space on datastore 1 for the SQL server that is the current owner but also moves it to the datastore with the datadrives. So if I shut down SQL 2 everything should flip. SQL 1 will become owner and will move to datastore 2 as the owner.
Anything else I should check before doing the shutdown and migration?