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?