SQL 2014 Cluster 2 Nodes 3 instances
Windows 2012 R2
VMware ESXI 6.5
Today one of my iSCSI drives filled up. I went onto SQL and tried to shrink a large data base trans log file it failed to do so I I tried to add another drive to the VM and I lost my entire "E" drive on the 'E" drive is the install of the SQL 2014 server. and the data bases. I have backup drive of all databases and they are copied off to NAS drive daily.
My databases are ok
This instance was the first instance I installed and now it is gone.
I can get to the other instances but not the primary one.
The drives are shared between the nodes using iscsi and cluster manager.
I now have my E Drive back but it is empty. I need to get the instance back.
So I tried to install SQL 2014 again
I get to Cluster Node Configuration and it fails "There is no SQL Server failover cluster available to join.
Am I hosed? Do I need to reinstall SQL from scratch?