Transactional replication: Deadlock issue

Tech-Archive recommends: Fix windows errors by optimizing your registry

hi,

I have a replication setup like

DB1----Trans Repl---->DB2----Merge Repl(changes at subscriber only)----
DB3.

I am facing multiple problems now. Let me go one by one.

1.One fine day the when i checked the status for the trans
replication, it shows that there is some sort of deadlock situation
and the process need to be restarted. Then I changed the profile and
make query timeout to 3600. After some time the status says "the
snapshot for this replication is not yet available". What might be the
reason behind it and how to investigate it's cause.

2.Now for the above problem what I want to do is create a snapshot at
DB1 and then drop the transactional replication subscription and
copying the data from DB1 to DB2(as reinitializing from scratch will
erase the data in DB2 and also DB3) create a new subscription at DB2.
Now the problem in the above process is I am unable to copy the data
from DB1 to DB2 for a table which has autoincrement primary key. As
the same table is also under merge replication it is now allowing me
to insert the data.

Is there any other better process to handle this, or any other 3rd
party tool which will do this for me? I am really frustrated as it
seems there is something or the other to fix in the above setup all
the time.

Thanks
Rakesh.
.

Relevant Pages

  • Re: Table Synchronization across databases on the same server
    ... Triggers will add to the overhead of the application which uses DB1. ... should be able to use log shipping or transactional replication for what you ... you will be unable to update tables on db2. ...
    (microsoft.public.sqlserver.replication)
  • Re: Table Synchronization across databases on the same server
    ... > inhouse application which maintains a transactional database, DB2 also ... Since the DB1 is frequently updated the ... Anyway, I'm not very good at replication myself, I would encourage you to ...
    (comp.databases.ms-sqlserver)
  • how to configure one-way merge replication?
    ... database to another database. ... i set up a merge replication - DB1 is the ... The subscriber is pulling from DB1. ... Instead i want to just pull from DB1 into DB2. ...
    (microsoft.public.sqlserver.replication)
  • RE: Merge agent not giving Duplicate key error
    ... "Vikas Kohli" wrote: ... I have a Merge Replication setup with Dynamic Filter Hostname ... > I have a Primary key on Column "X" on an Article that is there on all the ...
    (microsoft.public.sqlserver.replication)
  • Re: Inactive Transaction/Log will not truncate after replication disabled
    ... I did what you said to re-establish the replication setup again but have ... of across two nodes that I did before and then disable publishing. ... perfectly to clean up all marks, the inactive transaction log is cleared up ...
    (microsoft.public.sqlserver.replication)