HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Why CDC records nothing while being enabled?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
cdcwhywhileenabledrecordsbeingnothing

Problem

I enabled Change Data Capture on some tables in a Microsoft SQL 2008 database. Both of the following queries return 1:

select top 1 is_cdc_enabled from sys.databases where name = N''

select top 1 T.[is_tracked_by_cdc]
    from sys.tables as T
        left join sys.schemas as S
        on T.[schema_id] = S.[schema_id]
    where S.[name] = N'' and T.[name] = N''


but when I change the data of a concerned table, cdc.__CT remains empty.

Why?

Solution

Check to make sure the SQL Agent is running, and that there is a capture job created that is enabled and running for the CDC instance, it should show Change Data Capture Collection Agent / executing.

Context

StackExchange Database Administrators Q#19789, answer score: 6

Revisions (0)

No revisions yet.