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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-29 : 12:10:59
|
| Sherry writes "We are implementing a SQL server 2000 database on data center o/s. From reading the manuals, we know that when the data center fails over, the sql server on the passive node goes through recovery as part of becoming the active node. The manual also says that we may lose 'in flight' transactions and we have to program to detect this failover situation. But it doesn't tell us how. Does anybody know how? Do we have to check for @@error = ???. Thanks, Sherry" |
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-08-30 : 12:08:02
|
| Don't have a failover cluster, but will share what I believe to be true.Assume an active/passive cluster configuration.When the active node fails over to the passive node, the startup of the passive node goes through a log recovery process. This means that transaction(s) "in-flight" (not yet committed), will be backed out to preserve the integrity of the DB. If the transaction is from a user query, then the user will need to resubmit the query which was caught "in-flight".If the transaction caught "in-flight" is from an application, then the application needs to detect that the transaction has failed and effectively wait maybe 30 seconds and then resubmit the transaction. Where applications have been modified to detect the failure, wait, then resubmit the transaction, they are called cluster aware applications.The detection of the failure depends on the application interface (this is a really weak area for me).HTHs solart |
 |
|
|
|
|
|
programming for failover detection