patternsqlMinor
Why CDC records nothing while being enabled?
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:
but when I change the data of a concerned table,
Why?
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.