title: How to add more columns in existing Change Data Capture (CDC) table without Losing any data
body: <p>I have a table in Microsoft SQL Server 2008 for which I have already enable CDC with 5 columns. It is already running and live in the production and having thousands of records. Now I need to add 4 new columns in the same table and enable data capturing for newly added columns as well.</p>
  
  <p>I tried following scenario:
  1. Created a new temp instance for CDC and copying all the data from original CDC to tempCDC instance. Now recreating the CDC instance with original name again and copying all the data from temp instance.</p>
  
  <p>But in that case the start Lsn columns in the CDC.change_tables get reset. I stored the original start Lsn and and replace it with original start Lsn as well in the table CDC change_tables.</p>
  
  <p>But still it is not working and it seems that when recreating the instance it is resetting the start Lsn on some places internally.</p>
  
  <p>Thus I am unable to view the report based on CDC enabled table.</p>