0

I have dedicated server to setup transactional replication.

i want to replicate 3 tables only Availability Database.

The tricky part is, I want my transactional replication to continue automatically if automatic failover happen.

Is there any way to achieve this plan?

Transactional replication to continue even the failover happen on availability database.

zul nasir
  • 1
  • MS have [docs](https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-replication-for-always-on-availability-groups-sql-server?view=sql-server-ver16) for that. Is there a particular point in there that you're having trouble with? – Ben Thul Jun 09 '23 at 14:25
  • Hi Ben. Please share the links. Seems i could not find it. – zul nasir Jun 09 '23 at 14:31
  • I did - that word "docs" in my previous comment is a hyperlink to what I believe is the relevant documentation. – Ben Thul Jun 09 '23 at 16:56
  • Hi Ben, thank you so much. have successfully setup the transaction replication with FO capability. Now i have another question. Is the any way that the distributor server to have FO capability? – zul nasir Jun 18 '23 at 13:54
  • You're in luck! In that same document linked to above, there's a reference to another one. Search it for "Configure distribution database in an availability group". – Ben Thul Jun 18 '23 at 16:26

0 Answers0