SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database

Learn how you can add transactional replication to an AG to move data to an Azure SQL Database.

Transaction Replication: Multiple Publishers, Single Subscriber

How to configure multiple publishers and single subscriber replication?

Monitoring Transactional Replication in SQL Server

If you are using replication in SQL Server, you can monitor it in SSMS, but it makes sense to monitor distribution jobs automatically, especially if you can set up alerts or even set up first-line remedial action when a problem is detected. Francis shows how to do it in T-SQL as an agent job.

Steps to Rename a Subscriber Database for SQL Server Transactional Replication

I have transactional replication configured in production. The business team has a requirement to rename the subscription database. Is it possible to rename the subscription database and ensure that transactional replication will continue to function as before? If so, how could we achieve this?

Initialize SQL Server replication using a database backup

You need to configure transactional replication for a very large SQL Server database. Instead of running the snapshot agent to initialize the subscriber, in this tip we look at how you can initialize the subscriber from a SQL Server backup.

Replication

Transactions in Transactional Replication

SQL Server MVP Paul Ibison takes a look at how transactions are handled in replicated environments and the implications of rollbacks.

sync with backup