Availability Group with Replication

Question

Availability Group with Replication

sqlguru

SSC-Addicted

Points: 471
More actions
May 17, 2021 at 6:50 pm

#3884532

I have configured availability group for automatic failover with synchronous mode. So that way we can run the business for 24hrs. However, I am planning to configure replication. So when the role changes I want replication to handle itself without any manual intervention. Would that be possible? Please advise?
August 7, 2023 at 5:06 am

This was removed by the editor as SPAM
April 3, 2024 at 8:19 am

This was removed by the editor as SPAM

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

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

Yes possible, a simple google search came up with this from Microsoft

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-replication-for-always-on-availability-groups-sql-server?view=sql-server-ver15#:~:text=%20Configure%20replication%20with%20Always%20On%20availability%20groups,Replication%20PublishersA%20secondary%20replica%20cannot%20act...%20More%20

sqlguru SSC-Addicted Points: 471 More actions · Answer 2

So I decided to go with remote distribution so that would need additional SQL Server.

Does the collation of the remote distribution server has to match with the publisher? Please advise?

sqlguru SSC-Addicted Points: 471 More actions · Answer 3

Let me rephrase that. I have SQL Server publisher database with server Latin1_General_Bin collation and it is part of availability group. So I will configure remote distribution server to handle the failover of availability group and so that replication can work without manual intervention. Does the remote distribution server needs to have same collation as SQL Server publisher?

Jacob Ashton Newbie Points: 1 More actions · Answer 4

You cannot place a distributor database in an availability group using SQL Server 2012 and SQL Server 2014. Placement of a propagator database in an availability group is supported in SQL 2016 and later versions. But exceptions will be propagator databases used in merge, bidirectional, or peer-to-peer replication topologies.

I work at bestcustomwriting.com

sqlguru SSC-Addicted Points: 471 More actions · Answer 5

I followed below link and it is not working when I do the failover.

https://techcommunity.microsoft.com/t5/sql-server-support/setting-up-replication-on-a-database-that-is-part-of-an-alwayson/ba-p/318171

Any thoughts?

woodan Newbie Points: 1 More actions · Answer 6

woodan

Newbie

Points: 1

October 30, 2022 at 5:20 pm

#4106530

Thanks its good