Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SQL 2000 not failover to second node

  
   Database Forums (Home) -> Clustering RSS
Next:  Questions about SQL 2005  
Author Message
Miguel Araujo

External


Since: Dec 15, 2007
Posts: 2



(Msg. 1) Posted: Sat Dec 15, 2007 5:32 pm
Post subject: SQL 2000 not failover to second node
Archived from groups: microsoft>public>sqlserver>clustering (more info?)
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?

 >> Stay informed about: SQL 2000 not failover to second node 
Back to top
Login to vote
Linchi Shea

External


Since: Mar 03, 2006
Posts: 234



(Msg. 2) Posted: Sat Dec 15, 2007 9:56 pm
Post subject: RE: SQL 2000 not failover to second node [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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?

 >> Stay informed about: SQL 2000 not failover to second node 
Back to top
Login to vote
Miguel Araujo

External


Since: Dec 15, 2007
Posts: 2



(Msg. 3) Posted: Sun Dec 16, 2007 7:59 am
Post subject: RE: SQL 2000 not failover to second node [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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:

> 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?
 >> Stay informed about: SQL 2000 not failover to second node 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
2 Node Active/Passive - Failover when switch rebooted. - Hi Despite being directly connected with a crossover cable and each server being connected in to the switch, they seem to think that they need to failover when the switch goes off line. Why? Surely they should only be checking connectivity if the..

"Setup failed to perform required operations on the cluste.. - I created a single node SQL 2000 cluster for testing purposes on Windows 2003 SP1 box. In time, the application folks wanted to test failover and requested a failover node. I added the failover node to the cluster group and to the SQL cluster. I..

SQL Cluster Failover Notifications - Hello, We have a 2 node active/passive SQL 2005 cluster and were wondering if anyone knows if there is a solution which would allow someone to be notified automatically should the active node failover to the passive node? Maybe an email being sent? ...

Single Database Failover - Is it possible to set up SQL Server clustering so that only one database would failover or is it an all or nothing type thing.

New to Clustoring/Failover Questions - Simply put we have a Single SQL 2005 server running our applications. This server runs great, low load, databases under 200 meg mostly, maybe 2 gig of total data. We do backup via NetVault to tape everynight. What we want though, is a SECOND,..
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]