September 4, 2012 at 12:03 am
I'm using SQLSERVER 2008R2 with HA config using async mirroring. on the principal server, i also activate change data capture (cdc).
this is the problem, when I pause mirroring, agent cdc could not continue capturing logs for data changes. But when I resume mirroring, automacally agent cdc capture again the change log.
why this happen?
September 6, 2012 at 12:16 am
More info please. How are you determining that CDC stops capturing changes?
July 24, 2017 at 9:06 am
CDC uses the log reader, same as replication. When mirroring or availability groups are used, by default the log reader will not process log records that have not already been hardened at all mirroring / availability group secondary replicas.
This can be changed with Trace Flag 1448, which enables the replication log reader to move forward even if the asynchronous secondary replicas have not acknowledged the reception of a change. Even with this trace flag enabled, the log reader always waits for the synchronous secondary replicas.
References:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply