Disable Publishing and Distribution Servers

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

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

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

4- Confirm Disable is Wizerd or T-SQL

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

Wait for me in another Replication posts

Regards ,

Mostafa Elmasry

Published by Mustafa EL-Masry

I am Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I do it in multiple customers here in KSA and as of now, I am working in Bank Albilad managing the core banking system that is hosted in SQL Server Database 8 TB. Also, I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) For more information check my page https://mostafaelmasry.com/about-me/ View all posts by Mustafa EL-Masry