Share via


PublicationMonitor.CleanUpTracerTokenHistory Method

Definition

Removes metadata for tracer tokens from a database published using transactional replication.

Overloads

CleanUpTracerTokenHistory(DateTime)

Removes all metadata for tracer tokens older than the specified date from a database published using transactional replication.

CleanUpTracerTokenHistory(Int32)

Removes metadata for a specific tracer token from a database published using transactional replication.

CleanUpTracerTokenHistory(DateTime)

Removes all metadata for tracer tokens older than the specified date from a database published using transactional replication.

public:
 void CleanUpTracerTokenHistory(DateTime cutoffTime);
public void CleanUpTracerTokenHistory (DateTime cutoffTime);
member this.CleanUpTracerTokenHistory : DateTime -> unit
Public Sub CleanUpTracerTokenHistory (cutoffTime As DateTime)

Parameters

cutoffTime
DateTime

The date and time before which to remove the tracer token history records.

Remarks

The CleanUpTracerTokenHistory(DateTime) method is supported only with transactional replication.

The CleanUpTracerTokenHistory(DateTime) method can only be called by members of the sysadmin fixed server role on the Distributor or by members of the db_owner or replmonitor fixed database roles in the distribution database.

Calling CleanUpTracerTokenHistory(DateTime) is equivalent to executing sp_deletetracertokenhistory (Transact-SQL) at the Distributor.

Applies to

CleanUpTracerTokenHistory(Int32)

Removes metadata for a specific tracer token from a database published using transactional replication.

public:
 void CleanUpTracerTokenHistory(int tracerTokenId);
public void CleanUpTracerTokenHistory (int tracerTokenId);
member this.CleanUpTracerTokenHistory : int -> unit
Public Sub CleanUpTracerTokenHistory (tracerTokenId As Integer)

Parameters

tracerTokenId
Int32

The ID of the tracer token to remove from the publication database and all subscription databases. Use the EnumTracerTokens() method to return all existing tracer tokens for a monitored publication.

Remarks

The CleanUpTracerTokenHistory(Int32) method is supported only with transactional replication.

The CleanUpTracerTokenHistory(Int32) method can only be called by members of the sysadmin fixed server role on the Distributor or by members of the db_owner or replmonitor fixed database roles in the distribution database.

Calling CleanUpTracerTokenHistory(Int32) is equivalent to executing sp_deletetracertokenhistory (Transact-SQL) at the Distributor.

Applies to