In this post I share with you several recurring questions on managing disks in a cluster failover Windows.
1. Mount points and SQL Server
SQL Server supports mount points if and only if at least one letter named as primary disk for instance. Then you can add your mount points.
SQL Server support for mounted volumes (SQL 2000,2005 and 2008): “SQL Server failover clustered instances fully support mounted drives if the mounted drive is hosted by a cluster drive with a drive letter assigned.Note Because of the number of available drive letters, the number of the virtual instances on a cluster is limited to 25. SQL Server 2005 has the same limitation….”
2. Sharing a disk resource between several group SQL
A resource disk that is already allocated to group SQL can not be reused for another instance in another SQL group.
3. Cluster Shared Volumes (CSV) and SQL Server
CSV is only usable with HyperV for storing virtual machine. It is not so far, an official communication to extend this type of storage to another type of data / configurations.
4. Using disks dynamic with cluster
Dynamic disks are not supported natively with Windows 2008 cluster configuration (http://support.microsoft.com/kb/237853).
However, if you add a third product for managing dynamic disks you can have a support of the editor of the latter.
On the other hand, you will find the following link for information on basic vs. dynamic disks.
Michel Degremont | Microsoft EMEA
Product Support Services Developer – SQL Server Core Engineer |