When you have a replication in your environment what pre requesting we need to do. 1. Generate script out of subscriber database, include Trigger, indexes etc, useful for snapshot reapply. 2. Find which server is Distributor (Local same server or remote / different server), Publisher (All publication) And subscriber (All subscription) 3. Find out how replication topology designed. Ex: How many distributor, publisher and subscriber, one publication with many subscriptions or one publication with one subscription etc. 4. Script out all distributor, publication and subscription Go to replication folder in SSMS -> generate script of Distributor alone and save it Then choose generate script out of publication property and save…

Replication Technology Replication is a set of SQL agent job which will be created while configuring replication. This Replication SQL Agent job will copy and send data and database objects (Tables i.e Articles, SP, Views & UDF etc) from one database to another database. There will be three roles in replication i.e. Source DB server is publisher and destination/Target DB server is subscriber. In between there will be distributor DB server. All three will communicate with each other. We can have all 3 in the same servers or 2 severs or each one will be in dedicated server to configure replication. It is based on client requirement and DBA needs we choose…