CDC and AlwaysOn Availability Groups
CDC is fully interoperable with the new AlwaysOn features of SQL Server 2014. Additional complications arise when failover scenarios occur (from primary to replica). For these reasons, a few additional stored procedures have been provided that help this all out. In particular, If CDC is enabled for a database, but replication is not, the capture process used to harvest changes from the log and push them through CDC change tables runs at the CDC host as its own SQL Agent job. To resume the harvesting of changes after failover, you must run the sp_cdc_add_job at the new primary to create the new local capture job:
EXEC sys.sp_cdc_add_job @job_type = 'capture';
If you have both CDC ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
