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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy