Disable Publishing and Distribution Servers

1- Open MSSQL Distribution Server >>> mangment Studio >>> Replication >>> Write Click >>>> Disable Publishing and Distribution

Disable PDisable ublishing and Distribution

2- Disable this  Distribution and Publishing in this Server or Disable the Publishing and let the Distribution

Replic_5

3- Confirm Disabling Remote publisher this step if you add Remote Publisher

Confirm Remote Publisher

4- Confirm Disable is Wizerd or T-SQL

Replic_7

Now if you Checked the Distrubiter Database under the System Database you will not Found it also if you make write Clikc on Replication you will See Configure Distribution option that’s meaning this server without Distribution

Check

Wait for me in another Replication posts

Regards ,

Mostafa Elmasry

How to Add New Publisher Server to the Distributor Server (MSSQL Replication)

now if i need to Add new Publisher on my Distributor Server i will do this steps in SQL Server Also if you need to know hot to Setup the Cnfiguration of Distributor Server see this link :http://wp.me/p1Oidq-et or Check the replication categories :https://mostafaelmasry.wordpress.com/category/sql-server-2008/replication/

1- Connect to the MSSQL Distributor Server >>> mangement Studio >>> Replication >>> Write Click >>> Distributor properties

Replic_1

2- Add SQL publisher

Add SQL publisher

3- Add password to Connect the Publisher with this password to the Distributor

replic_3

Now if you Check the Distributor Server you will See 2 Publisher Server

Wait for me in another Replication posts

Regards ,

Mostafa Elmasry