Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change Data Capture 2008 Expand / Collapse
Author
Message
Posted Tuesday, October 30, 2012 9:25 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 10:02 PM
Points: 60, Visits: 79
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 !
Post #1378850
Posted Wednesday, October 31, 2012 12:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:42 AM
Points: 13,295, Visits: 11,086
Do you mean changes you made before you enabled CDC?

What kind of changes did you make?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1379164
Posted Wednesday, October 31, 2012 12:38 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 10:02 PM
Points: 60, Visits: 79
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.

Post #1379489
Posted Wednesday, October 31, 2012 1:47 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:42 AM
Points: 13,295, Visits: 11,086
There's a cleanup job that removes records from the change tables, so you might want to check into that.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1379511
Posted Thursday, November 1, 2012 5:52 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 3, 2014 9:25 AM
Points: 895, Visits: 2,432
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
Post #1379758
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse