1

Lots of questions in there. First, are we talking about transactional replication? I know you said that, but we need to be certain that you aren't talking about Always On Availability Groups, log shipping or some other solution to get a "copy" of your database. Answered: yes, transaction replication - I will refer to it as just "replication&...


1

Sure. The docs have plenty of detail on how, and specific details that might affect your implementation. I'd recommend configuring your distributor as a third, dedicated AG (assuming 2017+).


Only top voted, non community-wiki answers of a minimum length are eligible