Building an AG

Question

Building an AG

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
November 14, 2018 at 8:08 pm

#77835

Comments posted to this topic are about the item Building an AG

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

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

Stewart "Arturius" Campbell SSC Guru Points: 72624 More actions · Answer 1

Nice question, thanks, Steve
Have been revisiting HA for my new contract, so this one was easy

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Christoph Muthmann Ten Centuries Points: 1156 More actions · Answer 2

But this is not true for Basic Availability Groups, isn't it?

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-2016
An Always On basic availability group can be created on any two SQL Server 2016 Standard Edition servers. When you create a basic availability group, you must specify both replicas during creation.

Have a nice day,Christoph

Shayn Thomas SSCertifiable Points: 5863 More actions · Answer 3

nice questions steve,
ta

---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know

DinoRS SSCrazy Points: 2683 More actions · Answer 4

Hi Christoph,

as far as I know it does apply to Basic Availability groups, the limitations are different there it's more along the line of two nodes and only one DB per bAG (Basic Availability Group). WSFC is still a requirement