Re: ABNORMAL Transactional Replication behaviour

what does sp_browsereplcmds reveal? Run this in the distribution database to
see if commands are pooling there.

If they aren't run sp_repltrans in your publication database.

--
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

"newsgroup" <fabio.pliger@xxxxxxxx> wrote in message
news:nVn4f.10530$65.287427@xxxxxxxxxxxxxxxxxxxxx
> Actually i have set up a transactional replication with one publisher and
> 1 subscriber (planning, then, to add other 6 subscribers later on). The
> point is that after setting everything up, the replication works really
> fine for some minutes and then just stops without any warning or error!!
> The system is composed by this replication and some others applications
> that writes on some tables on the subscriber. This app starts writting
> data... everything works fine and then, BANG!, without any reason data is
> not sent to the publisher anymore! SQL server doesn't seems to notice
> that!
> The replication has itself some filters and some tables have numeric
> counters with identity YES (also the one that is written by the
> application i mentioned before) . But, when i set up the publication i
> assign a range to this counters and the replication blocks itself before
> reaching the 1 % of the range i assing to this field!!
> Anyone has an idea of what is happening?
> Please... somebody help me!!
>
> F.P.


.

Relevant Pages

  • Re: Replication Cleanup in high volume database
    ... We have one subscriber and are using RAID 10 as recommended. ... before moving to SQL 2005 x64, replication was the weak performance link. ... The distribution database has grown to 9GB in < a week. ... * What other parameters can be changed to keep the transactions only as ...
    (microsoft.public.sqlserver.replication)
  • Re: Fault tolerant distributor in merge replication and data mirroring (in SQL Server 2005/2008)
    ... but it's quite expensive and my customer doesn't ... When I said fault-tolerant I didn't mean "real time recovery", ... As it's a Merge Replication there can be this small downtime, ... tolerant system for the distribution database? ...
    (microsoft.public.sqlserver.replication)
  • The subscription(s) have been marked inactive and must be reinitialized.
    ... We have replication set up from our production system to 3 other servers. ... MSrepl_commands table on distribution database was filling up as a result ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication general question
    ... I know it is used in BOL and in a lot of other places. ... refuse to ever implement replication again, because "it doesn't work" or "I ... is on one server, part of the data on another server, and part of the data ... distribution database from server 2 and no agent in the system has the ...
    (microsoft.public.sqlserver.replication)
  • Re: General SQL Server 2005 transactional replication question
    ... Looking for a SQL Server replication book? ... presumably all my changes to that database are relayed to ... in the distribution database until it comes back up? ...
    (microsoft.public.sqlserver.replication)