Sql server active active alwayson

Question

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

Answer 1

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."

Answer 2

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.

Answer 3

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

Answer 4

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

Answer 5

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.