Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have just added a small (200 row) table to my current replication which has now broken my entire replication scenario as it seems to have broken the Log reader. The 2 tables are unrelated.

I am attempting to locate the table the related field is in and drop this table to see if that resolves the issue. Any other help in the meantime would be appreciated if anyone has come across this issue.

The errors I'm getting are:

The process could not execute 'sp_replcmds' on 'QUEEN'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)

Could not locate text information records for the column "MergeUpdateDesc", ID 28 during command construction. (Source: MSSQLServer, Error number: 18773)

The Log-Scan Process failed to construct a replicated command from log sequence number (LSN) {0022f069:000090cb:0026}. Back up the publication database and contact Customer Support Services. (Source: MSSQLServer, Error number: 18805)

The process could not execute 'sp_replcmds' on 'QUEEN'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)

share|improve this question

1 Answer 1

This is a bug with Replicating BLOBS in transactional replication. when the snapshot agent ran, something updated the BLOBs currently in the publication and this broke ALL replication streams.

After removing the initial table from the publication it moved onto another table containing BLOB data.

To resolve this I separated all tables containing BLOB data into their own Publication and removed them from my main publication. The Log Reader Agent then kicked back in.

share|improve this answer
1  
For future visitors: support.microsoft.com/kb/2655789 –  Paul White Sep 8 at 10:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.