Issue with changing data capture in SQL Server 2008 R2

After activating the CDC for the database I'm working on, I can’t fix anything at all in the capture task, I get the following errors: this kind of errors

SQL Server is SQL Server 2008 R2 SP3 on VMWare 10.x VM, with 8 GB of dedicated memory.

The actions that I performed, mainly using the database for cdc and then including a table for it, create a modification in this table and note that the write task did not help:

Service errors

Any advice would be HIGHLY appreciated!

Update: The problem is finally not resolved, I had to reinstall MSSQL 2008 R2, restore the db backup, turn on the CDC and work like a charm, who knows what was there before.

  • AL
+3
source share

Source: https://habr.com/ru/post/1208750/


All Articles