locked
SQL 2005 Cluster RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi all,

    i have  SQL 2005 cluster on windows server 2003 between two sites when the main site down the Witness is down also so the cluster service is down and all the cluster donw

    my question is can i have two witnesses so one at each site so if the link and network is down between the two sites the cluster still working

     

    Thanks

     

    Tarek

    Tarek Khairy
    Monday, June 6, 2011 10:10 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    No, quorum is between the witness and the principal and mirror, or the principal and wittness, or the mirror and wittness. With two wittnesses it might be possible for quorum to be established between the principal and wittness 1 and the mirror and wittness 2 - the classic split brain.

    So this is by design.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Monday, June 6, 2011 12:40 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hilary is right - it is by design to prevent splitbrain.  The only way to have automatic failver in the event of a site loss is to have your witness in a 3rd location that has connectivity to the other two locations.
    David A. Bermingham, MVP Senior Technical Evangelist, SIOS Technology Corp
    • Proposed as answer by Peja Tao Wednesday, June 8, 2011 3:44 AM
    • Marked as answer by tkhiry Thursday, June 9, 2011 7:37 AM
    Monday, June 6, 2011 3:43 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    No, quorum is between the witness and the principal and mirror, or the principal and wittness, or the mirror and wittness. With two wittnesses it might be possible for quorum to be established between the principal and wittness 1 and the mirror and wittness 2 - the classic split brain.

    So this is by design.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Monday, June 6, 2011 12:40 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hilary is right - it is by design to prevent splitbrain.  The only way to have automatic failver in the event of a site loss is to have your witness in a 3rd location that has connectivity to the other two locations.
    David A. Bermingham, MVP Senior Technical Evangelist, SIOS Technology Corp
    • Proposed as answer by Peja Tao Wednesday, June 8, 2011 3:44 AM
    • Marked as answer by tkhiry Thursday, June 9, 2011 7:37 AM
    Monday, June 6, 2011 3:43 PM