SQL Transaction Log Truncation when CDC is already applied.
I have a db that i have applied CDC on certain tables. On a client's request i have to truncate SQL server transaction log for that DB. Can any one tells me what would happen to my captured change data. Does SQL server persis that change data in captured tables. What would be the impact on captured table as it contains LSNs. What would happen to cleanup job as it also require LSN from captured table ?