The following email came in to a discussion group last week asking several questions about CDC including the interoperability of CDC and database mirroring.
Here are some questions regarding CDC in SQL Server 2008:
- 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?
- If disaster occurs, what will happen to CDC and what we should do to ensure the transactional consistency?
- Is it possible to combine database mirroring technology with CDC? Are there any possible risks?
Any information would be appreciated, thanks in advance!
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