SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL is running on only one node in the cluster. Should be running on two nodes in Active\Active...


SQL is running on only one node in the cluster. Should be running on two nodes in Active\Active configuration.

Author
Message
jyoti.patel
jyoti.patel
Valued Member
Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)

Group: General Forum Members
Points: 71 Visits: 154
Hi All,

Two sql server 2005 instances are configured by Active\Active cluster configuration and working fine but every day we dont know what happen i saw the email like"SQL is running on only one node in the cluster. Should be running on two nodes in Active\Active configuration."

Can any one tell me the resone why both nodes not running on diff nodes or why we have to manually move node to preferred node.
Divine Flame
Divine Flame
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2307 Visits: 2816
jyoti.patel (5/9/2012)
Hi All,

Two sql server 2005 instances are configured by Active\Active cluster configuration and working fine but every day we dont know what happen i saw the email like"SQL is running on only one node in the cluster. Should be running on two nodes in Active\Active configuration."

Can any one tell me the resone why both nodes not running on diff nodes or why we have to manually move node to preferred node.


1.Check in cluster administrator that on which node each SQL Server is running to verify that you are getting right alerts.
2. If the alerts are true & everyday nodes move on to a single node then check the SQL Server error log & Window's event viewer to see what caused SQL Server to restart?

SQL Server should not be restarting every day in ideal situation.


Sujeet Singh
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search