SNHA31: Configure transactional replication with Availability group cluster

In this video, I demonstrate how to configure SQL Server Transactional Replication in an Always On Availability Group (AG) cluster and explain the key design considerations, limitations, and best practices. Transactional Replication with AG is a common requirement in enterprise environments, but it comes with specific rules and caveats—especially around publisher configuration, failover behavior, and agent placement. This session walks through the end‑to‑end setup and highlights what you must know to avoid common pitfalls. Chapters: 00:18 - Transactional replication architecture 03:02 - Why need AG + Transactional replication? 04:15 - Requirements to create AG + transactional replication ---------------------------------- Preparing AG clusters 05:06 - Create AG for publisher 08:55 - Permissions for SQL Server agents 10:10 - Create AG for distributor 12:58 - Create AG for subscriber ---------------------------------- Starting to create transactional replication on top of AG 15:15 - Step 1: Configure distributor (in primary distributor) 17:25 - Step 2: Configure distributor (in secondary distributor) 18:06 - Step 3: Create distribution database (in primary distributor) 19:13 - Step 4: Add distribution database to distributionAG (in primary distributor) 21:29 - Step 5: Add distribution database (in secondary distributor) 22:17 - Step 6: Add primary and secondary publishers (in primary distributor) 23:30 - Step 7: Add primary and secondary publishers (in secondary distributor) 25:00 - Step 8: Setup publisher primary (in primary publisher) 26:37 - Step 9: Setup publisher secondary (in secondary publisher) 27:30 - Step 10: Enable publication in publisher database (in primary publisher) 29:00 - Step 11: Redirect distributor to publisher listener for all original publishers (in primary distributor) 31:12 - Step 12: Validate redirection (in primary distributor) 32:00 - Step 13: Confirm same linked servers in both primary and secondary distributors 32:36 - Step 14: Create publication (in primary publisher) 34:12 -Step 15: Give necessary login permissions 40:19 - Step 16: Create subscriptions (in primary publisher) 42:28 - Step 17: Create subscriber listener linked server in secondary publisher and secondary distributor 44:43 - Create publisher linked servers in secondary distributor 45:42 - Check publisher failover 50:41 - Check distributor failover 53:07 - Check subscriber failover All commands are in below github: https://github.com/Bobirmirzo/configu... Full course sessions: 🚀►   • Learning path: SQL Server Availability Gro...   🧑‍💼►Follow me on Youtube 🧑‍💼►Follow me on LinkedIn -   / bobirmirzo-arslanov-548960173   Full course sessions: 🚀►   • Learning path: SQL Server Availability Gro...   Watch all my playlists here: 🚀►Full course on Troubleshooting sessions:    • Troubleshooting   🚀►Full course on Encrypting connections to SQL Server-    • Full course on Encrypting connections to S...   🚀 ►SQL Server replication session:    • SQL Server replication   🚀 ►SQL Server Always On Availability Group:    • SQL Server Always On Availability Groups (AG)   🚀 ► SQL Server internals:    • SQL Internals   🚀 ► Course in On-memory OLTP:    • Course on In-Memory OLTP