From the Stack Exchange network

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?

asked 2021-10-15 by Rich Vieira

Answer

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

answered 2021-10-17 by Andy Mallon

Categories: Log Shipping, Replication, Server Fault, Stack Exchange