When the main server goes offline and the services start on the other server you may have to do a number of things to get the primary server online. Normally after you fix it you can restart the cluster service but fixing the server may require a reboot.
Now when the groups fail over to the secondary server (you are implying active/passive in your email) the sql service has actually has stopped for all practical purposes on the primary server and is trying to start up on the secondary server. The dependencies have to start first. Netbios names, IP addresses, disk resources, etc. If you were in the middle of a large Tx a lot of things may occur depending on what caused the primary to fail. >From my experience it seems as if you have to reconnect to the database since the sql service, in effect, has been restarted. Unless your desktop app makes continuous retries to redo the odbc connection you may have to restart the desktop app (i.e. close and open) in order for it to work. Hard Drive failure? You mean the shared scsi device? you have hardware RAID5 (or you better have). or the sys/boot drives on one of the nodes? - yes it will take serveral minutes for the other server to pick it up. I have seen in some cases that if the service did not start in a timely fashion (it said 'starting'- be it sql or exchange) that I have had to stop it and start it manually even though this is not supposed to be the case. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Timmerman Sent: Thursday, November 29, 2001 9:50 PM To: NT 2000 Discussions Subject: Windows 2000 and Clustering Is it true that in a Windows 2000 Cluster scenario (SQL Servers in my case) that when a failover occurs, you must reboot the server that is now primary in order for clients to connect? Also, if there is a harddrive failure in Server A, does it actually take Server B several minutes to respond? _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED] ------ You are subscribed as [email protected] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED]
