SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

CDC Interoperability with Mirroring and Recovery

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


No comments.

Leave a Comment

Please register or log in to leave a comment.