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…
| News From the Frontlines |  |
Tag Archive: CDC & Change Tracking
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….
(1 votes, average: 5.00 out of 5)
Loading ...-
My SQL Server Magazine Articles
- Database Mirroring for Disaster Recovery September 16, 2011
- Comparative Review: Database Schema Comparison Tools August 24, 2011
- 3 Log Shipping Techniques June 22, 2011
- Hardening SQL Server June 20, 2011
- Review: ScriptLogic Security Explorer for SQL Server February 8, 2011
-
Twitter
LinkedIn
TLF
RSS
WritersCafe
SQLPASS