all groups > sql server replication > june 2005 >
You're in the

sql server replication

group:

Transactional Replication Issue. Pls Help



Re: Transactional Replication Issue. Pls Help Narayana Vyas Kondreddi
6/29/2005 12:00:00 AM
sql server replication: Is the distribution agent running? Has it failed with an error?
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


[quoted text, click to view]

Transactional Replication Issue. Pls Help DJ
6/29/2005 9:01:02 AM
I have two databases say A and B on the same server. A is updated through an
Access front end. A is set up to transactionally replicate some of its tables
to B. The
Log Reader does its job - confirmed by running sp_browsereplcmds to see the
content of MSrepl_commands. However the Distribution Agent is not applying
Re: Transactional Replication Issue. Pls Help DJ
6/29/2005 1:56:04 PM
Does not run at all. I set up the replication with the option to leave the
tables on the subscriber intact. In other words, no initialization by way of
a snapshot .

[quoted text, click to view]
Re: Transactional Replication Issue. Pls Help Narayana Vyas Kondreddi
6/29/2005 11:20:21 PM
Not sure. What happens when you start the distribution agent explicitly?
What does the history say?
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


[quoted text, click to view]

Re: Transactional Replication Issue. Pls Help Paul Ibison
6/30/2005 9:10:28 AM
As well as Vyas' good advice, please check the owner of the job - if it is a
domain user please change to sa to take this potential cause out of the
frame.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button