yes static and readonly.

Good Evening JL;

Small in this instance is 7GB.

Downtime wise, as long as I want really as it is to be (eventually) merged into our existing data. But wanted to get...

Thanks Jeff..

That certainly clarifies the Automatic Failover options now. I clearly had it wrong!

Cheers again

Alex

And then if I brought back R1, waited for them to Synch and powered off R3 it would go straight to R1?

jeff.mason (4/22/2016)

---

To say you have 2 automatic failovers does not mean failover paths. It means you can define two nodes that can be automatic failover partners. R1...

I am still not following that counting.

If the R1 is the primary replica, and fails, R2 picks it up. That's 1 Move, right?

Now R2 is the primary; and fails; why...

The error message says '2 Automatic failovers only'

And thus the confusion. It must be semantics but 2 auto failovers to me is R1->R2 and R2->R3 is only 2.

I am not...

But I can only have two automatic failovers, right?

I have R1 Auto Failover (which in my mind should failover to R2)

And R2 Auto Failover (which in my mind should failvoer...

Well, upon re-looking at my AG configuration. I think I put up some bad information on it.

The group is configured as follows:

R1 -> Synchronous -> Automatic Failover

R2 -> Sycnrhonous ->...

Actually, No Jeff, I think the Group moving between the first two replicas is fine and adequate, and as you say, if we were to lose 2 replicas within a...

Aha! Makes sense.

Is there a way around this then? Fileshare witness? Or increasing the votes on the 3rd node?

As it stands, 3 nodes, each with a vote of 1 each.

Alex

Hi Jeff

When I look at the properties on the AG, both are Synchronous and both set to Auto.

But that isn't happening in the last worst-case scenario.

Is there anything else I...

Hiya,

I think I have had this problem - I solved it initially by increasing the timeout to about 5 minutes - which was a work around, and then later discovered...

Hi All,

I also read that JTDS doesnt support the automatic failover, but, I was hoping that, at best, the listener would always point to the primary replica and that simply...

Cheers! But that requires havng some Java skills in house, which we do not.

This is a third party application.

I don't even know if we have a Java compiler (and subsequently...