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 - 2008-02-19 : 14:36:23
|
| Hi thereCouple question about cluster especially for Active/Passive mode:1) Let say if you are running inserting within a transaction. In the middle of it, we initiate the failover and switch from node 1 to node 2. What is happening with that query? From my understanding, it will roll back ... correct? How about for SQL2000, is the same behaviour?2) How do I found in cluster when the node (resources) switch from one node to another? I know there is a cluster file called cluster.log but that info it's only holding 3 days information which I don't think keep any info about switch node. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 22:53:59
|
| 1. correct in both sql2k and sql2k5.2. check windows system event log. |
 |
|
|
dewacorp.alliances
452 Posts |
Posted - 2008-02-21 : 14:15:52
|
quote:
1. correct in both sql2k and sql2k5.
>>> It is roll back. Is it continue later on or not?quote:
check windows system event log.
>>> We set trashold for maintaining the system event log. Unfortunely, the event that we are looking for is not in the log. :( |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 14:37:56
|
| >>> It is roll back. Is it continue later on or not?No since sql restarted.>>> We set trashold for maintaining the system event log.Check sql server log, it tells you when restarted sql but not necessary due to cluster failover. |
|
|
|
|
|
|
Clarification about Cluster (Active/Passive)