HistoryRetention Property

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

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

Sintaxis

object
.HistoryRetention [=value]

Parts

• object
  An expression that evaluates to an object in the Applies To list.

• value
  A positive long integer. The default is 48 hours.

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetHistoryRetention(LPDWORD pRetVal);
HRESULT SetHistoryRetention(DWORD NewValue);

Notas

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.

Applies To:

DistributionDatabase Object