ReplicationServer.UninstallDistributor 메서드

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

네임스페이스:  Microsoft.SqlServer.Replication
어셈블리:  Microsoft.SqlServer.Rmo(Microsoft.SqlServer.Rmo.dll)

public void UninstallDistributor(
	bool force

매개 변수

유형: 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 방법: 밀어넣기 구독 삭제(RMO 프로그래밍) and 방법: 끌어오기 구독 삭제(RMO 프로그래밍).

  2. Delete all publications. For more information, see 방법: 게시 삭제(RMO 프로그래밍).

  3. Drop any distribution databases. For more information, see 방법: 게시 및 배포 비활성화(RMO 프로그래밍).

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.


커뮤니티 추가 항목