dbTalk Databases Forums  

SQL 2000 not failover to second node

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


Discuss SQL 2000 not failover to second node in the microsoft.public.sqlserver.clustering forum.



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

Default SQL 2000 not failover to second node - 12-15-2007 , 07:32 PM






I have a two node active/passive windows 2003 SP2 cluster.
I have three cluster groups created. One with MSDTC, the other with SQL
Server 2000 (I only have one instance) and the third with some other
resources like file shares.
When I move SQL Group to my second node it won't start unless I move first
the group that have MSDTC to the second node. If the group with MSDTC is on
second node, when I move SQL Group everything go well.

Is someone with the same problem?

Reply With Quote
  #2  
Old   
Linchi Shea
 
Posts: n/a

Default RE: SQL 2000 not failover to second node - 12-15-2007 , 11:56 PM






Did you check whether there were any error messages in the app
eventlog/errorlog that may explain why?

Linchi

"Miguel Araujo" wrote:

Quote:
I have a two node active/passive windows 2003 SP2 cluster.
I have three cluster groups created. One with MSDTC, the other with SQL
Server 2000 (I only have one instance) and the third with some other
resources like file shares.
When I move SQL Group to my second node it won't start unless I move first
the group that have MSDTC to the second node. If the group with MSDTC is on
second node, when I move SQL Group everything go well.

Is someone with the same problem?

Reply With Quote
  #3  
Old   
Miguel Araujo
 
Posts: n/a

Default RE: SQL 2000 not failover to second node - 12-16-2007 , 09:59 AM



When I move to node 2 only SQL Server leaving the cluster group with MSDTC on
node 1 I only get an entry in event viewer related to SQL Server saying "
[sqsrvres] OnlineThread:
ResUtilsStartResourceService failed (status 5b4)



"Linchi Shea" wrote:

Quote:
Did you check whether there were any error messages in the app
eventlog/errorlog that may explain why?

Linchi

"Miguel Araujo" wrote:

I have a two node active/passive windows 2003 SP2 cluster.
I have three cluster groups created. One with MSDTC, the other with SQL
Server 2000 (I only have one instance) and the third with some other
resources like file shares.
When I move SQL Group to my second node it won't start unless I move first
the group that have MSDTC to the second node. If the group with MSDTC is on
second node, when I move SQL Group everything go well.

Is someone with the same problem?

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.