dbTalk Databases Forums  

SQL_Server group fails over to seconday node during power failure

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


Discuss SQL_Server group fails over to seconday node during power failure in the microsoft.public.sqlserver.clustering forum.



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

Default SQL_Server group fails over to seconday node during power failure - 06-06-2005 , 11:06 AM






Hello,

I have a problem that perhaps someone could share some suggestions on how to
resolve it.

We have a SQL Cluster with a primary and secondary node. We also have a
File/Print Cluster with a primary and secondary node. Both clusters are in
the same rack with two UPS’s. The server room switches over to a back-up
generator during a power failure and the UPS only has to hold up the servers
for 10 or 15 seconds before the emergency power comes on-line.

When a power failure occurs, all of the resources are still on the primary
node of the File/Print server. However, on the SQL cluster, the SQL_Server
group has failed over to the secondary node. Cluster Group and Group 0 are
still on the primary node.

Does anyone have any suggestion on how to resolve this issue?

Thanks in Advance,
Danny Veals


Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL_Server group fails over to seconday node during power failure - 06-06-2005 , 11:14 AM






Put your network switch on the same UPS. NIC port failure will cause a
failover of a SQL server virtual instance.

Geoff N. Hiten
Microsoft SQL Server MVP

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

Quote:
Hello,

I have a problem that perhaps someone could share some suggestions on how
to
resolve it.

We have a SQL Cluster with a primary and secondary node. We also have a
File/Print Cluster with a primary and secondary node. Both clusters are in
the same rack with two UPS's. The server room switches over to a back-up
generator during a power failure and the UPS only has to hold up the
servers
for 10 or 15 seconds before the emergency power comes on-line.

When a power failure occurs, all of the resources are still on the primary
node of the File/Print server. However, on the SQL cluster, the SQL_Server
group has failed over to the secondary node. Cluster Group and Group 0 are
still on the primary node.

Does anyone have any suggestion on how to resolve this issue?

Thanks in Advance,
Danny Veals




Reply With Quote
  #3  
Old   
Danny Veals
 
Posts: n/a

Default Re: SQL_Server group fails over to seconday node during power fail - 06-06-2005 , 11:44 AM



Thanks Geoff, that make a lot of sense. I'll be to moving the network switch
over to the same UPS as the SQL cluster tonight.

"Geoff N. Hiten" wrote:

Quote:
Put your network switch on the same UPS. NIC port failure will cause a
failover of a SQL server virtual instance.

Geoff N. Hiten
Microsoft SQL Server MVP

"Danny Veals" <Danny Veals (AT) discussions (DOT) microsoft.com> wrote in message
news:7C600649-43FD-4461-8252-0B7B01CEA2C2 (AT) microsoft (DOT) com...
Hello,

I have a problem that perhaps someone could share some suggestions on how
to
resolve it.

We have a SQL Cluster with a primary and secondary node. We also have a
File/Print Cluster with a primary and secondary node. Both clusters are in
the same rack with two UPS's. The server room switches over to a back-up
generator during a power failure and the UPS only has to hold up the
servers
for 10 or 15 seconds before the emergency power comes on-line.

When a power failure occurs, all of the resources are still on the primary
node of the File/Print server. However, on the SQL cluster, the SQL_Server
group has failed over to the secondary node. Cluster Group and Group 0 are
still on the primary node.

Does anyone have any suggestion on how to resolve this issue?

Thanks in Advance,
Danny Veals





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.