dbTalk Databases Forums  

question about failover

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss question about failover in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Reddi
 
Posts: n/a

Default question about failover - 10-18-2004 , 11:57 AM






Hi,


In MS Clustering the failover happens only at hardware level or it can also
happen at application level? I mean If I am running two nodes, node1 & node
2. both these servers hardware has no issues but SQL server on node1 has some
problem, will it be able to use SQL server on node2?

Thanks

Reddi



Reply With Quote
  #2  
Old   
Rodney R. Fournier [MVP]
 
Posts: n/a

Default Re: question about failover - 10-18-2004 , 12:03 PM






Sure. If a resource stops responding either due to hardware or software
failure, it will fail over. You can test this by using the Move Group
command from the Cluster Administrator tool.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog

"Reddi" <Reddi (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,


In MS Clustering the failover happens only at hardware level or it can
also
happen at application level? I mean If I am running two nodes, node1 &
node
2. both these servers hardware has no issues but SQL server on node1 has
some
problem, will it be able to use SQL server on node2?

Thanks

Reddi





Reply With Quote
  #3  
Old   
Reddi
 
Posts: n/a

Default Re: question about failover - 10-20-2004 , 01:39 AM



Thanks for your time Rod!

Reddi

"Rodney R. Fournier [MVP]" wrote:

Quote:
Sure. If a resource stops responding either due to hardware or software
failure, it will fail over. You can test this by using the Move Group
command from the Cluster Administrator tool.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog

"Reddi" <Reddi (AT) discussions (DOT) microsoft.com> wrote in message
news:F05B1776-F173-4795-A0ED-6751749AB867 (AT) microsoft (DOT) com...
Hi,


In MS Clustering the failover happens only at hardware level or it can
also
happen at application level? I mean If I am running two nodes, node1 &
node
2. both these servers hardware has no issues but SQL server on node1 has
some
problem, will it be able to use SQL server on node2?

Thanks

Reddi






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.