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.
| Author |
Topic |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2012-10-30 : 10:54:17
|
| 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..why audited records in the cdc table got cleared next day..Thanks for your help in advance ! |
|
|
|
|
|
Change data capture