Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL is running on only one node in the cluster. Should be running on two nodes in Active\Active configuration. Expand / Collapse
Author
Message
Posted Wednesday, May 9, 2012 4:35 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, November 15, 2013 2:18 AM
Points: 71, Visits: 150
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.
Post #1297006
Posted Wednesday, May 9, 2012 4:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:47 AM
Points: 1,337, Visits: 2,624
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
Post #1297017
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse