0

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?

AMtwo
  • 237
  • 1
  • 6
Rich Vieira
  • 1
  • We will need a lot more detail to answer your hypothesis, which is not a question. You need to formulate a proper question if you are expecting an answer from people here. – Barnabas Busa Oct 15 '21 at 11:42
  • OK I guess the first question is can I have Log Shipping and Transactional Replication configured on the same Publishing Database? – Rich Vieira Oct 15 '21 at 11:47

1 Answers1

0

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

AMtwo
  • 237
  • 1
  • 6