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.