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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2007-09-05 : 09:23:54
|
| Hi thereWe've added new SAN disc (J - data2 and K - tlog2) into a cluster resource (at the moment we have F - data1, G - tlog1 and Q - quorum) and set offline the SQL resource and put those resource disks into dependencies ad set back online.Do the failover and turn out that it didn't move node 2 to node 1 (at the moment the active node is 2). It always stays to Node 2.When you do a moving resource, I can see that F, G, K and L has X mark on it and then set back to online again but it never move from node 2 to node 1.Any ideas? BTW where I can find the logs for the cluster to see this issue in detail?I'm appreciated your comment. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-05 : 12:32:13
|
| You should see the errors in Event Viewer.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-05 : 17:19:43
|
| under system drive, windows, cluster, cluster.log (i think)when you added the volumes, did you present them all to all of the nodes?if not then you need to represent them...let the nodes see them and own them... you do this one node at a time...HTH--------------------keeping it simple... |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2007-09-05 : 20:29:36
|
quote:
under system drive, windows, cluster, cluster.log (i think)when you added the volumes, did you present them all to all of the nodes?if not then you need to represent them...let the nodes see them and own them... you do this one node at a time...
How do present them in both nodes cause it's only 1 active node. Can you give some lights on this? I think this bit that I miss. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-05 : 22:49:57
|
| Did you see j: and k: in disk admin on node 1? |
|
|
|
|
|
|
|
|
Adding new SAN Disks and FailOver Issue