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...."
Known issue: FIX: You are prompted to format the volume when a formatted volume is mounted on a NTFS folder that is located on a computer that is running Windows Server 2008 or Windows Vista
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.
In Windows Server® 2008 R2, the Cluster Shared Volumes feature included in failover clustering is only supported for use with the Hyper-V server role
4. Using disks dynamic with clusterDynamic 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.http://blogs.msdn.com/clustering/archive/2009/12/16/9937435.aspx
Michel Degremont | Microsoft EMEAProduct Support Services Developer - SQL Server Core Engineer |
Description of the problem: You want to install SQL server 2005 administration tools.However during the installation, you do not have the check box to checked for client components. And no error message was raised during the phase of pre-validation installation.
Cause : In the log, we find the following error message that indicates that Management Tools has been disabled because IE 6 SP1 is not installed on the server:Internet Explorer 6 SP1 is not installed, therefore the Business Intelligence Workbench, Report Designer, and SQL Server Workbench features will be disabled. Action: Install Internet Explorer 6 SP1 for the Business Intelligence Workbench, Report Designer, and SQL Server Workbench features to be enabled.
Extract log: %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\ SQLSetup0001_MachineName_WI.log
For more information : How to: View SQL Server 2005 Setup Log Files
Resolution: Installing Internet Explorer 6 SP1 is a prerequisite: Hardware and Software Requirements for Installing SQL Server 2005 Extract documentation : « Microsoft Internet Explorer 6.0 SP1 or later is required for SQL Server Management Studio, Business Intelligence Development Studio, and the Report Designer component of Reporting Services.»