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 |
|
MuadDBA
628 Posts |
 Posted - 2004-03-25 : 11:24:54
|
| We're setting up a new project, and I was discussing the function of an active/passive SQL server cluster configuration, and how, when the active server dies,open connections are broken and in-process transactions are rolled back.The Project Manager asked if there was any software out there that was capable of persisting those active conections and transactions over to the passive (which will become active) server.Anyone know? |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-03-25 : 12:15:19
|
| Not that I know of. It takes about 30-90 seconds to fail from one node to the other. During that time, you'll get "Could not connect to SQL Server" errors on your client application. If you handle those properly, you should be pretty much OK. Ideally, the active server will not die that often so this will not be a super huge issue.BE SURE THAT THE HARDWARE YOU GET IS CLUSTER AWARE AND CLUSTER CERTIFIED!! I can't stress that enough.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
|
|
|
My PM wants me to ask this....