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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » In The Enterprise » SQL is running on only one node in the...

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

Rate Topic

Display Mode

Topic Options

Author

Message

jyoti.patel

Posted Wednesday, May 09, 2012 4:35 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 1:45 AM
Points: 71, Visits: 146

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

Divine Flame

Posted Wednesday, May 09, 2012 4:48 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 5:48 AM
Points: 1,076, Visits: 1,922

jyoti.patel (5/9/2012)

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.

- Divine Flame

Post #1297017

« Prev Topic | Next Topic »

Permissions