Change Tracking Auto Cleanup - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Change Tracking Auto Cleanup

Author

Topic

omonney
Starting Member

2 Posts

Posted - 2009-07-31 : 02:56:45

I cannot see if cleanup task is executed correctly on time

I enabled change tracking to database and table "dbo.T_TEST".
I set database:
Retention Period = 2
Retention Period Units = Minutes
Auto Cleanup = True
I do changes to database and test by this sql query:
"select ID, sys_change_operation from CHANGETABLE(CHANGES dbo.T_TEST, 1) AS CT"
I get the change I did.

When I re-execute the query after the retention period (even after 1 day), I still get a non empty resultset. Should I normally get an empty resultset?
Is it a way to make a clean-up manually?

I'm working on SQL Server 2008 SP1

Thanks for any help
Olivier

omonney
Starting Member

2 Posts

Posted - 2009-08-03 : 02:46:18

I did changes to dbo.T_TEST last friday, and this monday i ran my query:
"select ID, sys_change_operation from CHANGETABLE(CHANGES dbo.T_TEST, 1) AS CT"
I got an empty resultsest!!!
After 3 days!

Anybody have the same problem?

If I want to work with Microsoft Synchronization Framework, I won't wait each time 3 days to test validity of subscribers...

Thanks if anybody can share experience

Olivier

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources