As you know Change Data Capture harvests transactions from the log file. I was wondering what happens when the log file gets truncated during transaction log backups or when an automatic checkpoint takes place on a database in simple recovery mode causing log truncation. What if the CDC job has not harvested those records in the portion of the log to be truncated. I had the feeling that the SQL Engine ensured that this would not happen but I wanted to understand the internals of this process. turns out, with all the information available about CDC it was hard to find a straight answer on this. But I did.
All things data, data platforms, community and sometimes random thoughts on technology.
Saturday, February 19, 2011
Wednesday, January 12, 2011
My SQL saturday #62 schedule
My SQL Saturday #62 schedule:
This are the sessions I think I will be attending:
8:30 Efficient Data Wharehouse Design
9:45 SSIS Cafeteria
11:00 Cool tricks to pull from your SSIS hat
12:15 Accelerating BI Development with BI xPress
1:30 MDX 201
2:45 SQL Smackdown: SSIS Vs PowerShell
4:00 Creating a Metadata Mart w/ SSIS - Data Governance
It will be very SSIS oriented as you can see.
Hope to get a chance to catch up with many of you during this SQL Event
Luis
This are the sessions I think I will be attending:
8:30 Efficient Data Wharehouse Design
9:45 SSIS Cafeteria
11:00 Cool tricks to pull from your SSIS hat
12:15 Accelerating BI Development with BI xPress
1:30 MDX 201
2:45 SQL Smackdown: SSIS Vs PowerShell
4:00 Creating a Metadata Mart w/ SSIS - Data Governance
It will be very SSIS oriented as you can see.
Hope to get a chance to catch up with many of you during this SQL Event
Luis
Subscribe to:
Posts (Atom)