Clustering question

כל התגובות

• יום שני 16 אפריל 2012 17:53

   

   
  

  0
  I 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?

  ---

  sqldev

  • תגובה
  • ציטוט

   
• יום שני 16 אפריל 2012 18:27

  מנחה דיון

   

   
  

  0

  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.

  http://technet.microsoft.com/en-us/library/cc771259.aspx#DiskFailover

  http://technet.microsoft.com/en-us/library/cc732035(v=ws.10).aspx

  • סומן כתשובה על-ידי Vincent HuModerator יום רביעי 18 אפריל 2012 08:39
  •  
  • תגובה
  • ציטוט

   
• יום שלישי 17 אפריל 2012 06:40

   

   
  

  0

  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.

  -ridhuan-

  • תגובה
  • ציטוט