Disabling Publishing and Distribution
Disabling publishing and distribution includes disabling the Distributor and Publishers, deleting the distribution database, and deleting publications and subscriptions.
By using the Disable Publishing and Distribution Wizard, SQL-DMO, or scripts with Transact-SQL system stored procedures on the Distributor, you can:
- Delete all distribution databases on the Distributor.
- Disable all Publishers that use the Distributor and delete all publications on those Publishers.
- Delete all subscriptions to the publications. Subscription information at the Subscriber will not be deleted, and you should delete it manually. Data in the publication and subscription databases will not be deleted; however, it loses its synchronization relationship to any publication databases. If you want the data at the Subscriber to be deleted, you need to delete it manually.
To disable publishing and distribution
SQL-DMO