October 30, 2012 at 9:25 am
I 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 !
October 31, 2012 at 12:44 am
Do you mean changes you made before you enabled CDC?
What kind of changes did you make?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 31, 2012 at 12:38 pm
The 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.
October 31, 2012 at 1:47 pm
There's a cleanup job that removes records from the change tables, so you might want to check into that.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 1, 2012 at 5:52 am
You might want to check the retention period (Retention Period Units) to and see what its set to, se this as a guide http://msdn.microsoft.com/en-us/library/bb895205.aspx
_________________________________________________________________________
SSC Guide to Posting and Best Practices
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply