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: 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
read more

Will CDC work on a database in SQL 2000 Compatibility Mode?

This question came up today on Twitter via the #sqlhelp hash tag. To be perfectly honest, I wasn’t sure. There were a lot of functions and internal constructs added for CDC (Change Data Capture). I could easily see it not working or having limited functionality in compatibility mode 80. So I devised a little test. Rather than breaking out each part of the test and explaining it, I included inline comments for each section. I didn’t do an all encompassing
read more