Forum Discussion

shivkumarm's avatar
shivkumarm
Copper Contributor
Jan 23, 2024

Transactional Replication - Publisher Issue

We have 3 Node SQL Server Cluster (Always On availability group). I wanted to implement Transactional Replication on 3rd Node which is configured as Asynchronous.   When I tried to create Publis...
BabatundeDallas's avatar
BabatundeDallas
Brass Contributor
Jan 24, 2024

shivkumarmthe 3rd error suggests that the database is part of a mirroring session or an availability group. You must  suspend or remove it from these configurations to perform the necessary operations.  For mirroring, you can use: 

ALTER DATABASE [prod] SET PARTNER SUSPEND

 You may need to temporarily remove the database from the availability group for availability groups or ensure the availability group is configured correctly and the secondary replicas are accessible for read access.

 

After resolving these issues, you should be able to set up Transactional Replication on Node 3 or Node 2. Remember to reconfigure mirroring or availability groups after completing the replication setup.

 

Always perform these operations during scheduled maintenance windows and ensure you have tested them in a non-production environment before applying changes to a production system.

 

 Let me know if this works for you. @ me in replies, or I'll lose your thread!!!  
Note: 

If this post helps, please consider Accepting it as the solution to help others find it more quickly. OR
If my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
 
Best Regards,
Dallas.

Resources