Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hannah00
Starting Member
31 Posts |
 Posted - 2007-08-02 : 22:49:41
|
| We have SQL cluster crashed today b/c the active node had some issues with the SAN Storage, the question is why it doesn't fail over to the passive node if the active node had some issues instead of crashing.thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-02 : 23:21:40
|
| If something is wrong on storage, passive node can't connect to it either. |
 |
|
|
hannah00
Starting Member
31 Posts |
Posted - 2007-08-03 : 09:07:30
|
| it's not the problem with the storage, there is an issue with HBA card of this node and the storage, when the switch to another card, everything came back happy, my question is if there is an issues with the HBA on this node, it should have fail over to passive node. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-03 : 11:21:41
|
| Not really, cluster service may still count it as storage issue. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2007-08-09 : 18:51:31
|
| hannah00 - Do you have two HBA's in each node of the cluter? If so, do you have them setup for Fail-Over (redundant pathing) or Performance (I can't recall the right word here).If the HBA's are setup in failover mode, the active node should have some software on it to decect a failed HBA, and send the data down the other HBA to the SAN.If you only have one HBA in each node (which is a bad practice, you should have two in failover mode IMHO), then MSCS should have detected the active node could not see the storage and started failover to the passive node.You probably need to do some testing during a maintenence window of the different types of failovers (removing cables from HBA's / switches, poping a disk our of your SAN (which should not cause a cluster failover, but see if it does or not, etc).Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of Microsoft Corp. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
|
|
|
|
|
SQL CLUSTER CRASHED due the failure with SAN stora