Online Documentation for SQL Administrator for SQL Server

Configuring change tracking


Change tracking in SQL Server 2008 and higher enables applications to obtain only changes that have been made to the user tables, along with the information about those changes.

Change tracking is an important building block for applications that synchronize and replicate data in scenarios in which end-to-end replication solutions do not work and a custom solution is required.

 

Database Editor - Configuring change tracking

 

 

!CheckBox Change tracking enabled

Use this checkbox to enable or disable change tracking for the database.

Note: To enable change tracking, you must have permission to modify the database.

 

Retention period

Specify the minimum period (in days, hours or minutes) for keeping change tracking information in the database. Data is removed only when the Automatically cleanup is enabled.

The default retention period is 2 days. The minimum retention period is 1 minute.

 

!CheckBox Automatically cleanup change tracking information after retention period

Indicates whether change tracking information is automatically removed after the specified retention period.

Enabling Auto Clean-Up resets any previous custom retention period to the default retention period of 2 days.