From Server Fault

Can I use both Log Shipping and Transaction Replication at the same time?

Rich Vieira asks about the feature compatibility of using AlwaysOn Availability Groups and Replication on the same database.

Andy MallonOctober 15, 20211 min read

The original question, asker attribution, and answer are preserved below.

Question

Good Morning, I have a SQL Server 2016 that is doing Log Shipping to a DR Site. I currently want to also to Replicate (Transactional) specific Tables to another Server for Reporting Purposes.

Will there be any issues or snafu’s I should be aware of? Can I have Log Shipping and Transactional Replication configured on the same Publishing Database?

Asked2021-10-15byRich Vieira

Answer

Transactional Replication and Log Shipping are totally compatible features, and both can be used on the same published database.

Answered2021-10-17byAndy Mallon

Categories: Databases

Tags: Log Shipping, Replication, Transaction Logs