Database Properties (ChangeTracking Page)
- Change Tracking
Use to enable or disable change tracking for the database.
To enable change tracking, you must have permission to modify the database.
Setting the value to True sets a database option that allows change tracking to be enabled on individual tables.
You can also configure change tracking by using ALTER DATABASE.
- Retention Period
Specifies the minimum period for keeping change track information in the database. Data is removed only if the Auto Clean-Up value is True.
The default value is 2.
- Retention Period Units
Specifies the units for the Retention Period value. You can select Days, Hours, or Minutes. The default value is Days.
The minimum retention period is 1 minute. There is no maximum retention period.
- Auto Clean-Up
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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback