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.