question

mukkimehra-8904 avatar image
0 Votes"
mukkimehra-8904 asked ·

Sql server active active alwayson

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-supported
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Sirlupinwatson avatar image
0 Votes"
Sirlupinwatson answered ·

Hi @mukkimehra-8904




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

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

mukkimehra-8904 avatar image
0 Votes"
mukkimehra-8904 answered ·

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.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeonLaude avatar image
0 Votes"
LeonLaude answered ·

Hi,

Q&A currently supports the products listed over here https://docs.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


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

mukkimehra-8904 avatar image
0 Votes"
mukkimehra-8904 answered ·


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

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yes it should be doable.

Step-By-Step: Creating a SQL Server 2012 AlwaysOn Availability Group
https://docs.microsoft.com/sv-se/archive/blogs/canitpro/step-by-step-creating-a-sql-server-2012-alwayson-availability-group


0 Votes 0 ·
mukkimehra-8904 avatar image
0 Votes"
mukkimehra-8904 answered ·

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.

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

You should be asking the experts in this area, they can provide more guidance and assistance, you can reach them over here:
https://social.technet.microsoft.com/Forums/en-US/home?forum=sqldisasterrecovery


0 Votes 0 ·