September 9, 2019 at 12:08 pm
Hi,
I got a requirement to configure basic Alwayson availabillity group in sql 2016 standard edition.
May i know prerequisites.
For Basic Always on do we need Active directory,Fail over cluster, and DNS?
I got 2 new blank vms. Do i need to add this two nodes in fail over cluster??? I have to do it everything from scratch. Please help what else i can do it to configure the basic alwayson in standard sql 2016.
Thanks,
Jo
September 9, 2019 at 10:41 pm
The requirements are the same for basic availability groups as they are for enterprise availability groups:
Prerequisites, Restrictions, and Recommendations for Always On availability groups
And this has an overview on setting it up:
How to Set Up Basic Availability Groups in SQL Server 2016
Sue
September 10, 2019 at 11:15 am
Thank you very much.. How many databases we can add in the Standard Allwayson group?
I see only one db can be added in the standard edition. What if we want to add more dbs to group?
Can you please clarify.
September 10, 2019 at 11:24 am
You can have one database in a basic availability group and can't add databases to the group - that's one of the difference with enterprise availability groups. You can have multiple availability groups though with either edition.
Sue
September 11, 2019 at 5:13 am
Thanks Sue.
Sure. once we configure the Basic Always on configuration in Standard edition can i apply license of the enterprise edition later on for SQL Server? Then we can add multiple dbs to alwayson group..
Please suggest is this ok to do it?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply