david.puckett 38841 (7/25/2014)
3 node windows 2012 failover clustersql2012 installed on node 1 and node 2
node 1 and node 2 -> instance 1 using V: on san as clustered storage
from node 1 v: drive information (get-disk ## | select-object *)
* IsClustered : True
node 3 -> no instance yet using V: on san as standalone storage
from node 3 v: drive information (get-disk ## | select-object *)
* IsClustered : False
To set the drive letter to V: in 2012 as V: is already in the cluster we had to use "Computer Manager"
I'm thinking the SQL install is seeing the cluster V: and not the local V:
So, how to get SQL to see the local V: and *should* SQL be installed on the local V: instead of an available drive letter.
Error message when trying to install SQL on node 3 V:
The directory V:\{path} is not a valid path. Standalone SQL Server on WFC cluster cannot have the files on shared disk locations.
You need to:
(1) Evict the standalone node from the WSFC cluster
(2) Install the sql on that node
(3) Add the node back to the cluster.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]