SQL Transactional Replication send to data into SQL AG setup

Question

Post reply

SQL Transactional Replication send to data into SQL AG setup

SQL Galaxy

One Orange Chip

Points: 29472
More actions
August 25, 2022 at 6:40 am

#4080377

Hi,
Proposing technique with multiple High availability solution, Please suggest will work or not.
Site A - SQL Server transactional replication will be configure act as a publisher and distributor role.
Site B - SQL AlwaysOn Availability Group set configured. and AG listener will share to site A for transfer data into site B in AG setup will act as a subscriber
Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

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

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

So if I understand the question.

Can an AOAG setup be a subscriber to a transactional replication publication?

Yes it can but you need to do some additional configuration to set it up correctly

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/replication-subscribers-and-always-on-availability-groups-sql-server?view=sql-server-ver16

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 2

Hi Ant-Green thanks for update.

Yes. AOAG setup be a subscriber to a transactional replication publication. and Subscriber receiving records at every seconds from publisher. So please suggest if any what are the key parameter closely should be monitor based on data movement and performance.

Thanks.