CDC: CDC is working with one database for same server but not other database

Posted on 2015-02-02
Last Modified: 2015-03-15

I've one database server where CDC is enabled.
But I could not capture data in CDC tables in another database. In SQL agent job, it is giving below error:

"Change Data Capture has scanned the log from LSN{0006DC4E:000CE092:0001} to LSN{0006DC4E:000D61F0:0003}, 500 transactions with 14708 commands have been extracted. To report on the progress of the operation, query the sys.dm_cdc_log_scan_sessions dynamic management view."

Error # 22803

Could you please look into it?
Best Regards,
Mohit Pandit
Question by:MohitPandit
  • 2
LVL 15

Accepted Solution

Aaron Shilo earned 500 total points
ID: 40593260

do you have CLOB , BLOB on that DB?
If a table that you are looking to enable CDC on has BLOB fields you will need to modify the "max text repl size" to it's maxiumum allowed value (2147483647) otherwise you will get truncation errors.  This is a replication setting but because CDC piggybacks on the functionality this is where you would need to make the change.

Author Comment

ID: 40598258
Okay, let me check on it & update you.

Best Regards

Author Closing Comment

ID: 40667352

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 r2 - Varible Table 3 24
Sql Server group by 10 27
insert wont work in SQL 14 21
I have a SQL Select with a where clause that has an issue. 6 38
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question