Post reply

Does multi-subnet with standardeditionofsqlserver supports DB Mirror Or AG group

  • September 26, 2023 at 9:51 am

    #4295360

    Does multi subnet failover with standard edition of sqlserver supports DB Mirror or AG groups

    1. can db mirror configured in different multi subnet with standard edition

    2. can db always on configured in different multi subnet with standard edition

    Thanks
    Naga.Rohitkumar

  • September 26, 2023 at 9:59 am

    #4295362

    Yes & Yes

    But don't use mirroring it is depreciated and will be removed in a future version of the product.

  • September 26, 2023 at 10:45 am

    #4295397

    HI Ant-Green , can you provide any document where i can have prerequisites for always on can be configured in  different subnets (IP"S)

    because i need to submit to client before i configure they should see the document or link as proof

    Thanks
    Naga.Rohitkumar

  • September 26, 2023 at 10:46 am

    #4295398

    HI Ant-Green , can you provide any document where i can have prerequisites for always on can be configured in  different subnets (IP"S)

    with standard 2019 sqlserver edition because i need to submit to client before i configure they should see the document or link as proof

    Thanks
    Naga.Rohitkumar

  • September 26, 2023 at 11:07 am

    #4295413

    There is plenty on the internet for this topic on "how to setup a multi-subnet aoag" standard/enterprise doesn't matter it's the same thing you do, your just limited to 2 replicas (primary & secondary) and basic availability groups.

  • September 27, 2023 at 6:27 am

    #4295924

    Hi I have to configure Always on DB standard edition

    i have installed 2019 standard edition sqlserver basic installation , now for always on what additional services i need to add to the existing sql server in installation ,

    does analysis and reporting , integration services needed

    or what needed to select in installation features in 2019 standard edition

    Thanks
    Naga.Rohitkumar

  • September 27, 2023 at 8:02 am

    #4296005

    Setting up an AOAG is no different in Standard as it is in Enterprise, everything is exactly the same, except the edition limitations you must use BAG's and not AG's, you're limited to 2 replicas not 8.

    But in terms of doing everything else, setting up the cluster, IP's, SQL on the replicas it is 100% the same regardless if you're using Standard or Enterprise.

     

    You don't need anything other than the DB Engine, a WSFC (if you want the HA/DR piece) and the necessary holes punched in the right firewalls.

     

    Google, Bing, DuckDuckGo are your friends, there are lots of articles on the web on how to setup the whole thing from start to finish, the first hit would generally get you Brent's setup guide (yes its 2016 but nothing has changed)

    https://www.brentozar.com/archive/2015/06/how-to-set-up-standard-edition-alwayson-availability-groups-in-sql-server-2016/#:~:text=Enable%20AlwaysOn%20Availability%20Groups%20on,Server%20service%2C%20and%20click%20Properties.&text=On%20the%20AlwaysOn%20High%20Availability,to%20Enable%2C%20and%20click%20OK.

  • September 30, 2023 at 4:37 am

    #4298152

    SQL server "Availability group" is not available in some versions of SQL server.

     

    DBASupport

Viewing 8 posts - 1 through 7 (of 7 total)

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