http://www.sqlservercentral.com/blogs/robert_davis/2010/11/29/CDCInteroperabilitywithMirroringandRecovery/

Printed 2014/07/26 05:28AM

CDC Interoperability with Mirroring and Recovery

By Robert Davis, 2010/11/29

CDC Interoperability with Mirroring and Recovery

The following email came in to a discussion group last week asking several questions about CDC including the interoperability of CDC and database mirroring.

The email:

Dear experts

Here are some questions regarding CDC in SQL Server 2008:

  1. What will happen to CDC if we truncate or backup database log files? Will the operation wait for CDC log parser to complete all of the transactions?
  2. If disaster occurs, what will happen to CDC and what we should do to ensure the transactional consistency?
  3. Is it possible to combine database mirroring technology with CDC? Are there any possible risks?

Any information would be appreciated, thanks in advance!

My response:

This post was cross-posted from the main SQLSoldier blog. Please visit the source blog to read the whole post and leave a comment: http://www.sqlsoldier.com/wp/sqlserver/cdcinteroperabilitywithmirroringandrecovery


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.