Tag Archives: Cdc & Change Tracking

CDC Interoperability with Mirroring and Recovery

November 29, 2010 1:15 pm / 3 Comments /

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 … Read More →

Posted in: SQL Server / Tagged: , , , ,

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

August 30, 2010 1:06 pm / Leave a Comment /

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. … Read More →

Posted in: SQL Server / Tagged: , ,