This Q&A was previously posted on the Database Administrators Stack Exchange website.
This content is licensed under the Creative Commmons Attribution-Sharealike (CC BY-SA) license. As the author of these answers, this archive serves as a canonical location for permalinks, which will outlive Stack Overflow. See all my answers by looking at the DBA Stack Exchange post category.
Can I use both Log Shipping and Transaction Replication at the same time?
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