Standard SQL 2016 Basic availability configuration

  • pols

    SSC Eights!

    Points: 848

    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

  • Sue_H

    SSC Guru

    Points: 90287

    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

  • pols

    SSC Eights!

    Points: 848

    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.

  • Sue_H

    SSC Guru

    Points: 90287

    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

  • pols

    SSC Eights!

    Points: 848

    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