After activating CDC for a database I'm working on, the capture job fails to actually capture anything, I'm getting these kind of errors:
The SQL Server is SQL Server 2008 R2 SP3 on a VMWare 10.x VM, with 8GB RAM assigned.
The steps I did where basically enabling the database for cdc, and then enabling a table for it, create a modification on that table, and notice that the capture job didn't do it's work:
Any piece of advice will be GREATLY appreciated!
Update: Problem finally not solved, had to reinstall MSSQL 2008 R2, restored a db backup, enabled CDC and worked like a charm, who knows what happened there before.
- AL