TheSQLGuru (10/3/2016)

---

szejiekoh (10/3/2016)

---

Hi all,

I understand that mirroring is no longer recommended but the setup exists in my current environment

I am trying to understand the portion on log truncation between alwayson...

thank you guys! yeap i have also done the tests and observed the same behavior :w00t:

thanks nicholas and simon for the wonderful replies and thoughts

Nicholas Cain (9/18/2016)

---

That's the way that WSFC is designed and functions. There must always be a quorum of votes.

Ultimately, should you desire, you could configure the node weight of...

Nicholas Cain (9/16/2016)

---

The worst case isn't whether a node is down or not, that's not what causes split brain scenarios. Rather the issue is when both nodes are up, and...

Nicholas Cain (9/16/2016)

---

Well if you don't have quorum then your AG will be down. It requires quorum to function (otherwise how would it know which was the primary). In your...

thank you guys! I guess I will patch it without shutting down 1st 😛

Hi Kris,

Understood that. Have tried it out and the patch did stop and start up the instance for me.

But i would still prefer to do a proper shutdown before the...

GilaMonster (8/23/2016)

---

szejiekoh (8/23/2016)

---

Actually, what i am trying to clarify is that a 2 node WSFC will still need share disk (fileshare aside) for voting/quorum even though always on availability group...

Hi Perry,

Thanks for your explanation! We are all reading your stairways to alwaysOn ;)!

Base on your replies, can i said that

AlwaysOn Availbility doesn't need shared storage, but it needs...

GilaMonster (8/22/2016)

---

szejiekoh (8/22/2016)

---

I wanted to sort this out because people are telling me that you can have a 2 node window cluster setup without any form of share disk at...

GilaMonster (8/22/2016)

---

Yes, it must be on a cluster.

As I said above, recommeded quorum model is either node majority or node and file share depending how many nodes you have (you...

Hi Gila,

Please let me know...

GilaMonster (8/22/2016)

---

Always On is a marketing term that encompases multiple features.

Always On Windows Failover Clustering required shared storage, just like clustered SQL instances always have.

Always On Availability Groups does not...

Hi Gila, Hugo, and everyone,

Thanks for showing me the light, I get the reason now !

Sorry for the slow reply!

Regards,

Noob