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