HistoryRetention Property (SQL-DMO)

The HistoryRetention property specifies the number of hours to maintain replication distribution history data.

Applies To

Syntax

object.HistoryRetention [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list.
value	Positive long integer. The default is 48 hours.

Remarks

Installing replication creates a SQL Server Agent job responsible for cleaning the replication history tables. Rows in the tables older than the current hour minus the retention period are targets of the cleaning.

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetHistoryRetention(LPDWORD pRetVal);

HRESULT SetHistoryRetention(DWORD NewValue);