Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

a weird problem?

 
   Database Help (Home) -> Replication RSS
Next:  trigger problem - "if update" on text t..  
Author Message
Joe111

External


Since: Aug 19, 2004
Posts: 70



(Msg. 1) Posted: Tue Dec 30, 2008 7:11 am
Post subject: a weird problem?
Archived from groups: microsoft>public>sqlserver>replication (more info?)

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

 >> Stay informed about: a weird problem? 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 145



(Msg. 2) Posted: Tue Dec 30, 2008 7:19 am
Post subject: RE: a weird problem? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Joe - the same fix for SQL Server 2005 is in CU10:
http://support.microsoft.com/kb/958684
HTH,
Paul Ibison, www.replicationanswers.com

 >> Stay informed about: a weird problem? 
Back to top
Login to vote
Joe111

External


Since: Aug 19, 2004
Posts: 70



(Msg. 3) Posted: Tue Dec 30, 2008 7:50 am
Post subject: RE: a weird problem? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I hope it works Paul, because we really need it to work.

Thanks for your prompt reply and interest.

P.S.
I just don't understand why doesn't MS put a link for the same problem for
other versions on the same KB or it does not enter in the result set of the
search.

"Paul Ibison" wrote:

> Hi Joe - the same fix for SQL Server 2005 is in CU10:
> http://support.microsoft.com/kb/958684
> HTH,
> Paul Ibison, www.replicationanswers.com
>
 >> Stay informed about: a weird problem? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Replication problem - I have a problem with rows deleted at subscriber could not get deleted at publisher in particular case where article published say table1 has row filter like "SELECT <published_columns> FROM [dbo].[TABLE1] WHERE ([FILED1]='XYZ ' OR [FI...

Problem with synchronisation - Hi, We have the problem with synchronisation. On the Client using SQLExpress a message appears "Not enough virtual memory" In the sql log on the server are 2 error lines: 1) Replication-Replication Merge Subsystem: agent ..

Restoration problem in replication - My publisher server is crashed due to some virus attack.I have backup of this server,please let me know wht is the procedure for Restoration technique for this publisher.But my subscriber is working fine, now if i restored the publisher then will it...

Problem setting up Distributor - I am trying to setup SQL Server 2000 Replication between 2 servers QA1 and QA2. When I try to establish QA1 as the Distributor (using the Configure Publishing and Distribution Wizard), I get the following message: "SQL Server Agent on "QA1...

column filter problem - Hi All: I use merge replication in SQL server with column filter and row filter , it works fine. so that i generate a script. when i tried to run this script on another computer , i got warning as below: Warning: only Subscribers running...
   Database Help (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]