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...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAiggqReyiyEXocoPCNlzDNe8_0wWp4Gfohr2p2RJL9Mg__8EYm-y1thuW_Oh6dZqNtwrEXTS5IWOPHkWphI1EdKipTdPORDs0nqFtIZaB5GD8G4PKutRs9lNOUN3xnr6qqok0fCAE_RUQ/s640/1.PNG)
Click Add... and map to Server 1 which is configured as Distributor :
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjz1lKQ9a5VSTbFmQZpYtbTjcjBN77rX4KnH48UqNFDIGLMthsoLCDYsVQmybwFxNbcxD1jLE_vXP-YX1FjYm0t2KZfMS-8R4rR3fiwqsDpAEgF0NMOW4YA4bQ3Sxt3gsLGIS06qaov5BeK/s640/2.PNG)
Select Publication Database :
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_e4Y_n204LSwaHsXd1-s5chE7TDv46P2IS42B1LGd3V5grFvzxZ56OtNpcZJsKjHjKnwEBg0-rU8TlHYEFrSykTOzL7GbMXsVngbP-bGox0Xz-F_u8g13sX4vcwbjnJel3QweZurXXnxi/s640/3.PNG)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUpIqHjNSxVzekr41DMHgFvuK1FMJLzG_Sq1CeQXv3MLcym5tpnhr3BIjoE1i8GsHjB5benapISE4oCOmSnZfrHUGWglNQJau451wESR6ZptJKKP8s2XJRSEAsfPidX6poQhl0uYNMrqZr/s640/4.PNG)
Select objects to be published :
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuhXw7AkH8jlVkNM7iJeYX7haP_BLlEtxV0wjALa0Nm-z1SWv40ADU7l1oSITFK0t2bnUOzn9baTSYZpIxPaoHsa0OIBZoxE3puQTbkcRfL4gR0rXNifqgMrankGupcvyWz0EkTQiF98KJ/s640/5.PNG)
Filter Published Data
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRwIi6XnvRJpbhfADvy2koeHB13eHsphRKkWpzRyjlL3Epf62yGPDdeWQp0-3ZJD8lNnMUdOeWQaJfEcyGTeqOAYUMnQ8VCLs5NoZ82x_FmQro7iHF2uw-7exUrsryXyTxQsEzWiRfauIf/s640/6.PNG)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLWC3dbjrHU_vU-TMLVzi3o-ctsvIZwvseVVs6N9FK-X0KQc8oU_SuEp9Z4D3mYXlUuEFqWzQp81qmzF1Yg1tanPNhQfw2boreAucwzO-_xSuXTFu58r3CPAzK7uqaR63aDd5mnyF8Sdzc/s640/7.PNG)
Snapshot Agent Security
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5iCB8GteHNVczWvgqZotvov1so3WZnbhrG6Q7H6vbCWdbpuCRfA4aju4EN5HlrVtmSqJiguYHJzPJ6Zvcj8ZRJS1pAVMH6w_9IxWU_5rgp2wJINw4VLWJ_Pbg-WMd3ZjZg-SOh43PtejD/s640/8.PNG)
Provide the path for saving configuration scripts and click Finish:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgimnsWIBcAgJxQmIlmWWQ53iCi8iGVjW-mvUt1oGS4V2NWwauZqIY3az80hU46k3oL36bVnaLI5fVcW2O7ZO4zvZgq1p98-ok7tdtdXCk1gTZskh0ql4cRIgIPWhL2-iutXbrAA2uWpCTs/s640/9.PNG)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBQ4nrF8n88GAncxX7bfHvlMK946uSvbwDvCUIL33vj5bsOcummKnttreH2BGearOZjtuZlaGgbMDSRhiA1uTrYeBbje-MDAm_R-t0FslYnAQIzsT-VG0Kme6NJlzum20uJT3HR2FYzS8M/s640/10.PNG)
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