sql server replication: Tran-Repl error -- sql server replication

Tran-Repl error

sqldba
8/10/2006 11:29:18 PM

sql server replication:

I am getting folowing error from 2-3 different server for which i am doing
Transactional Replication. I checked my network, hardware & every thing is
fine. Windows Server 2000 & SQL 2000 are on latest SP. couple of times when
ever i get this error message, i stopped & started Distributor & Log reader
Job & it runs fine but i see same error message after 5-6 hours & stop for
5-6 days & see same error message coming back. my last option is to Drop &
RE-create Subscription, but i don't want to that. i am looking for root
cause & to FIX it. Error message is shown below.

Any help will be highly appreciated & thanking you in advance.

Error: 14152, Severity: 10, State: 1
Replication-Replication Transaction-Log Reader Subsystem: agent
Server_Name-Database-xx scheduled for retry. The process could not execute

Re: Tran-Repl error

myrights99 NO[at]SPAM gmail.com
8/11/2006 8:23:16 AM

Thanks for reply, but the LINK you mentioned is about SQL 2005 & the
problem i have is on SQL 2000. trying to understand from that LINK that
you give is also applicable to SQL 2000 or it is just for SQL 2005.
your comments will be appreciated.
Thanks for your help.

[quoted text, click to view]

Re: Tran-Repl error

Hilary Cotter
8/11/2006 11:37:56 AM

Enable logging to determine the exact nature of the problem. Here is a kb
article on how to do this.

http://support.microsoft.com/kb/312292/en-us

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Re: Tran-Repl error

myrights99 NO[at]SPAM gmail.com
8/11/2006 11:43:04 AM

Thanks Paul & Hilary for your help & quick respone, i appreciate.

[quoted text, click to view]

Re: Tran-Repl error

Paul Ibison
8/11/2006 4:33:04 PM

AFAIU this information is equally applicable to SQL Server 2000.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.