O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

EXEC sys.sp_cdc_add_job @job_type = 'capture';

If you have both ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required