יום שני 16 אפריל 2012 17:00
In the active-passive 2 node windows 2008 cluster which is currently in production use, I added two new drives and it's showing under available storage.
How can I add these two new drives as a SQL Server dependencies? Please let me know
יום שני 16 אפריל 2012 17:53I was able to add these two new drives as a SQL Server dependencies. How can I test the failover of these two newly added drives without bringing the production SQL Server down?
יום שני 16 אפריל 2012 18:27מנחה דיון
The recommendation before adding new storage to a cluster is to ensure that it passes the cluster validation storage tests. These include disk failover tests.
When cluster validation is performed on an already configured cluster, if the default tests (which include storage tests) are selected, only disk resources that are in an Offline state or are not assigned to a clustered service or application will be used for testing the storage. This builds in a safety mechanism, and the cluster validation wizard warns you when storage tests have been selected but will not run on storage in an Online state, that is, storage used by clustered services or applications. This is by design to avoid disruption to highly available services or applications that depend upon these disk resources being online.
- סומן כתשובה על-ידי Vincent HuModerator יום רביעי 18 אפריל 2012 08:39
יום שלישי 17 אפריל 2012 06:40
You can test the Failover between the SQL Clustered Disk by using an application ( I use MSSQL Management Studio) to connect to the SQL Cluster Network Name (Virtual Network Name). Check the connection while you move the service from 1 node to another. You will experience slight downtime around 15-20 seconds and the connection will return to normal. If the SQL Clustered Disk fails, the SQL Service will not be started after it is failover to other node.