locked
2008 Cluster Issue RRS feed

  • Question

  • Having issue with Microsoft 2008 SQL cluster nodes periodically failing over.

    Always see the same three entries in the error logs.

    1) quorum lost

    2) cluster service stopped

    3) removal of node from active membership

    Any direction would be appreciated.

    Monday, September 16, 2013 5:53 PM

Answers

All replies

  • Having issue with Microsoft 2008 SQL cluster nodes periodically failing over.

    Always see the same three entries in the error logs.

    1) quorum lost

    2) cluster service stopped

    3) removal of node from active membership

    Any direction would be appreciated.

    Sounds like what it says: you lost quorum. Check your network etc. This article may assist you in that:

    Having a problem with nodes being removed from active Failover Cluster membership?


    Andreas Wolter | Microsoft Certified Master SQL Server
    Blog: www.insidesql.org/blogs/andreaswolter
    Web: www.andreas-wolter.com

    • Proposed as answer by Fanny Liu Saturday, September 21, 2013 11:43 AM
    • Marked as answer by Fanny Liu Monday, September 23, 2013 8:59 AM
    Monday, September 16, 2013 6:04 PM
  • looks like the configuration is incorrect or there might be problem with your NIC cards or it is not up-to-date, also you need to work with

    Network

    OS team

    SAN -team

    inorder to analyze, also see in the clusterlog & eventlogs.

    if possible can you provide more logs here-


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Tuesday, September 17, 2013 11:59 AM