As mentioned in my previous post, In this post, let us see step by step tutorial in configuring publisher at server 2
In SSMS - > Under Object Explorer - > Replication - > Local Publications -> New Publication...

Click Add... and map to Server 1 which is configured as Distributor :

Select Publication Database :


Select objects to be published :

Filter Published Data


Snapshot Agent Security

Provide the path for saving configuration scripts and click Finish:


In SSMS - > Under Object Explorer - > Replication - > Local Publications -> New Publication...
Click Add... and map to Server 1 which is configured as Distributor :
Select Publication Database :
Select objects to be published :
Filter Published Data
Snapshot Agent Security
Provide the path for saving configuration scripts and click Finish:
No comments:
Post a Comment