important : About HA : in Which event , Automatic Repoint happens?

  • Hi

    I install Always on - sql server 2014

    Availibilty Mode : Synchronous commit

    Failover Mode : Automatic

    (Without Qurume Configuration - Only 2 servers : Primary And secondary)

    When I causes some error on Primary server (Fill all free space on Database Hard Drive ) , And All query return error about log is full ,

    But Didnot Any Automatic repoint ?

    And After some times , I Had to Do it myself !!!!!

    And After Manual Failover , old Primary Database , get suspect status .

    1- Then which Event should be done to , Automatic failover Happens?

    2- After Switch (Or Repoint) , What happens to connection , that connected to primary ?

    Thank you

  • Are you saying your filling the database in an attempt to failover the AO group??

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • I Thin I found the Problem.

    I dont have quorum

    And whitout quorum , automatic failover dont happend.

    yes ?

  • if you only have 2 nodes then you need to add a witness whether it be a disk or file share witness.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Yes I Have only one primary and one secondary .

    What is witness ? is that share storage ?

    Another Question ?

    What is diference between "Automat Failover" And "Automat Redirection"

  • Please help me

    Yes I Have only one primary and one secondary .

    For Automatic failover and Automatic redirection , Should I use create qurume (share storage) ?

    Another Question ?

    What is diference between "Automat Failover" And "Automat Redirection"

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply