Sql server active active alwayson

mukki mehra 1 Reputation point
2020-06-02T05:12:06.247+00:00

Hello Experts

I have two SQL instances running on Windows, SQL cluster having 2 Node with shared storage( Active, Active type)

SQL sever version is running on SQL 2012 Enterprise edition

Can we implement Alwayson on this for HA ,DR. Is it feasible then what are the complexities and steps.

Thanks

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,268 questions
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Armand Brunelle 491 Reputation points
    2020-06-02T05:36:43.237+00:00

    Hi @mukki mehra

    Here you can read about;

    - Always On availability groups; A high-Availability and Disaster-Recovery-Solution

    The way your configuration work right, You could do many move but your best bet is to go over here and read about what you really need;
    Prerequisites, Restrictions, and Recommendations for Always On availability groups

    Make sure configuration is using the same exploitation system, is not domain controlled and ensure that each computer is a node in a WSFC.
    You already have 2 clustered instance with sharding , see if you meet the requirements first, and make sure to have a backup failover but also check out requirements for your config understanding specifics clustering guidelines recommended. Failover Cluster Requirements

    APPLIES TO: YesSQL Server NoAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse
    Windows Server Failover Clustering (WSFC) with SQL Server

    "If the answer did help you, Upvote it, other user will access those informations swiftly."

    0 comments
  2. mukki mehra 1 Reputation point
    2020-06-02T05:58:07.653+00:00

    Thanks I have used FCI ie Active Passive Cluster having shared storage with alwayson AG for DR which is doable but didn't use
    For two node having two different Sql server instances for AG DR.

    Did not get any such info in particular with two SQL instances running having alwayson HA and DR implemented with 3 Nodes.

    0 comments
  3. Leon Laude 85,666 Reputation points
    2020-06-02T07:43:42.593+00:00

    Hi,

    Q&A currently supports the products listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

    You can reach out the experts in the dedicated "SQL Server - High Availability" forum over here:
    https://social.technet.microsoft.com/Forums/en-US/home?forum=sqldisasterrecovery

    (Please don't forget to accept helpful replies as answer)

    Best regards,
    Leon

    0 comments
  4. mukki mehra 1 Reputation point
    2020-06-02T12:12:18.933+00:00

    I have two SQL instances running on Windows, SQL cluster having 2 Node with shared storage( Active, Active type)

    SQL sever version is running on SQL 2012 Enterprise edition

    Can we implement Alwayson on this current setup for DR.

    I am asking Is it doable and how?

    Thanks

  5. mukki mehra 1 Reputation point
    2020-06-02T12:41:17.917+00:00

    Ok Leon thanks.

    But I am looking for all possible in outs on this configuration and steps to configure it or any upgrade to Alwayson is recommended here for current setup.