CDC capture job failed. Now I need to recover missing inserts


CDC capture job failed. Now I need to recover missing inserts



We utilize cdc for auditing purposes for changes to our user attributes, and their authorization to our role based solution. During a recent deployment we realized post deployment that change data was not being written and discovered that the change data capture job had failed several hours earlier. We have determined how to get the capture job up and running again.
CDC is enabled, but cdc.dbo<table-name>_CT table is not being populated



Now we need to recover inserts and updates that happened while the capture job was down. I can get that data, but I have no clue how to go about inserting the data into our cdc capture instances. Is such a thing possible? I know the $operation value. Can I get the $start_lsn from the Transaction Log? What about $seqval, and $update_mask? We inherited the cdc implementation, and have sparing knowledge of how it works, especially when it doesn't work.









By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

How to add background colour in existing image using Swift?

Moria Casán

How to make file upload 'Required' in Contact Form 7?