Microsoft® SQL Server 2012 Unleashed

CDC and AlwaysOn Availability Groups

CDC is fully interoperable with the new AlwaysOn features of SQL Server 2012. Additional complications arise when failover scenario’s 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:

Click here to view code image

EXEC sys.sp_cdc_add_job @job_type = 'capture';

If you have both ...