Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ReplicationServer.UninstallDistributor Method

Uninstalls replication publishing and distribution on the currently connected instance of SQL Server. 

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
public void UninstallDistributor(
	bool force
)

Parameters

force
Type: System.Boolean
A Boolean value that specifies whether or not replication objects are removed from the server, even if a remote Distributor cannot be reached. If true, the publishing and Distributor configuration at the current server is uninstalled regardless of whether or not dependent publishing and distribution objects are uninstalled. If false, all dependent publishing and distribution objects are dropped before the Distributor is uninstalled.

Before calling UninstallDistributor, you must first perform the following tasks:

  1. Delete all subscriptions. For more information, see NIB Delete a Push Subscription (RMO Programming) and NIB Delete a Pull Subscription (RMO Programming).

  2. Delete all publications. For more information, see NIB Delete a Publication (RMO Programming).

  3. Drop any distribution databases. For more information, see NIB Disable Publishing and Distribution (RMO Programming).

The UninstallDistributor method can only be called by members of the sysadmin fixed server role.

The UninstallDistributor method is equivalent to executing the sp_dropdistributor (Transact-SQL) stored procedure.

myDist.UninstallDistributor(false);
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.