Distribution Agent

Hi ALL, Greetings
I have set up Transactional Replication for my database, the distribution
agent stated and copied all the data in to subscriber, but its is giving me
error to copy the data again in to table, because the data already in the
table. it is giving me error that unable to load the data again. i started
the distribution agent again, it is giving mer the same error and stopped.
if i delete the data in distribution database, and start the agent? it will
work or not? i mean whcih tables should i clean up and restart the agent.
please advise me
Thanks in advance
John
John,
there must be something more to this. The distribution agent won't try to
copy the data again. Once the commands have been delivered, the XACT number
ensures only subsequent commands in msrepl_commands are read. Please can you
post up the entire error message.
Rgds,
Paul Ibison SQL Server MVP,
www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I think at this point it is best to drop your subscription, right click on
your publication and select properties.
Then click on the articles tab, click on article defaults, Table articles,
and OK. Click on the Snapshot tab, and ensure that either Drop the existing
table and re-create it is checked (preferably), or delete all data in the
existing table.
Then recreate your subscription and let it rip.
Hilary Cotter
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
"John" <John@.discussions.microsoft.com> wrote in message
news:1C185E1E-B740-442E-B6D1-39F7DB1F6EDD@.microsoft.com...
> Hi ALL, Greetings
> I have set up Transactional Replication for my database, the distribution
> agent stated and copied all the data in to subscriber, but its is giving
me
> error to copy the data again in to table, because the data already in the
> table. it is giving me error that unable to load the data again. i started
> the distribution agent again, it is giving mer the same error and stopped.
> if i delete the data in distribution database, and start the agent? it
will
> work or not? i mean whcih tables should i clean up and restart the agent.
> please advise me
> Thanks in advance
> John
>
>
>