New answers tagged alwayson
How did you setup your Availability Group? It sounds like what happened is you blanketed the backups and restores from the primary replica server to the secondary replica server. In other words, you did a: backup database <DatabaseName> to disk .... <so on and so forth> to all databases on the primary and a restore database ...
Yes CDC works with Failover Clustered Instances. It has since it was first introduced. There's nothing special that needs to be done to get it working. Just set it up like you would on a standalone non-clustered instance.
Refer to Replication, Change Tracking, Change Data Capture, and AlwaysOn Availability Groups (SQL Server) From the reference : Change Data Capture: Databases enabled for change data capture (CDC) are able to leverage AlwaysOn Availability Groups in order to insure not only that the database remains available in the event of failure, but that ...
Top 50 recent answers are included