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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy