February 1, 2015 at 2:17 am
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
February 1, 2015 at 7:07 am
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" 😉
February 1, 2015 at 11:02 pm
I Thin I found the Problem.
I dont have quorum
And whitout quorum , automatic failover dont happend.
yes ?
February 3, 2015 at 8:39 am
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" 😉
February 8, 2015 at 1:38 am
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"
February 14, 2015 at 4:32 am
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