Hello!
We have got a weird problem which we can't manage to understand. I'll be
grateful if anyone can help.
Here's the scenario:
We have got a 2 node Cluster SQL Server 2005 Enterprise Edition (SP2) on
Windows Server 2003 SP2 R2.
We set up Transactional Replication between these two nodes so that we can
use the second node as a reporting server for our long-running queries.
Secondary server is the distributor and transactions are pulled by this
server as a subscriber. I set up the replication using backup, I have not
initialize any snapshot as it takes too long and takes too much resource,
especially intensely consumes CPU.
After a successful period which was for about 2 weeks we got an error:
Error messages:
The process could not execute 'sp_replcmds' on 'VSQLGOZT\OLTP'. (Source:
MSSQL_REPL, Error number: MSSQL_REPL20011)
Get help:
http://help/MSSQL_REPL20011
An unexpected Text Information Begin (TIB) log record was encountered while
processing the TIB for offset 0. Last TIB processed: (textInfoFlags
0xfffffff5, coloffset 3248, newSize 0, oldSize 4294967296). Contact Customer
Support Services. (Source: MSSQLServer, Error number: 18834)
Get help:
http://help/18834
The Log Reader Agent failed to construct a replicated command from log
sequence number (LSN) {001327a0:00010ec1:000b}. Back up the publication
database and contact Customer Support Services. (Source: MSSQLServer, Error
number: 18805)
Get help:
http://help/18805
The process could not execute 'sp_replcmds' on 'VSQLGOZT\OLTP'. (Source:
MSSQL_REPL, Error number: MSSQL_REPL22037)
Get help:
http://help/MSSQL_REPL22037
When I googled for this error, I found out that this is a bug for SQL Server
2008 and there's a fix for it:
http://support.microsoft.com/kb/958496.
However there's nothing that mentions SQL Server 2005.
Things I'll try is to apply the new SP3 to these instances and if it does
not work, I'll try to convert TEXT and IMAGE fields to VARCHAR(MAX) and
VARBINARY(MAX) accordingly.
If there's anyone who faced this problem and have a solution please let me
know.
Thanks in advance,
Joe