Hi all,
Probably it is a silly question but I'm really confused about the behavior. MSDN defines the retention period as:
The change retention value specifies the time period for which change tracking information is kept. Change tracking information that is older than this time period is removed periodically.
I'm running SQL Server 2008 with Change Tracking enabled. I set the Retention Period
7, Retention Period Units Days and Auto Cleaned up
True.
Let say today, 26th Oct is the cutoff day of the retention period. Hence according to that link, all the change tracking that is older than 7 days will be removed. In my understanding, it will keep any tracking information between 19th and
26th Oct only. Tomorrow, it will keep the ones within period 20th and 27th Oct.
But I found different behavior. When syncing, I got an error indicated that change tracking has cleaned up tracking information, the local database (sdf) has to be reinitialized. I did last sync yesterday (it means no longer than 7 days) so I hope that
error didn't occur.
Could any of you explain me about these?
- Is my understanding about the concept (Retention Period) correct?
- Why did I get the error and how to avoid it?
- Is there any way to check the creation time of the change tracking?
Thanks,
Agung