InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 23:03:15 GMT20http://www.sqlservercentral.com/Forums/Topic1378850-392-1.aspxYou might want to check the retention period (Retention Period Units) to and see what its set to, se this as a guide [url]http://msdn.microsoft.com/en-us/library/bb895205.aspx[/url]Thu, 01 Nov 2012 05:52:30 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1378850-392-1.aspxThere's a cleanup job that removes records from the change tables, so you might want to check into that.Wed, 31 Oct 2012 13:47:29 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1378850-392-1.aspxThe changes i made after the cdc table enabled.I have updated a record in customer table and the changes showed up in the customer table and i see 2 records in teh cdc_customer table with before updated record and after update record.When check back next day the cdc_customer table doesn't have the 2 records.THe table has no records..Please suggest.Wed, 31 Oct 2012 12:38:07 GMTMvs2k11http://www.sqlservercentral.com/Forums/Topic1378850-392-1.aspxDo you mean changes you made before you enabled CDC?What kind of changes did you make?Wed, 31 Oct 2012 00:44:47 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1378850-392-1.aspxI have enable the change data capture on db and enabled one table and i made updates on couple of records in the transaction table and it logged the changes of the enabled CDC table updates in teh default cdc table.. However to my surprise i didn't see the records which were logged in earlier day..I have schedule the cleanup job after 60 days.EXECUTE sys.sp_cdc_change_job@job_type = N'cleanup',@retention = 86400; Please suggest if i missing anything which should not cleared the data after a day..Thanks for your help in advance !Tue, 30 Oct 2012 09:25:26 GMTMvs2k11