ABNORMAL Transactional Replication behaviour

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: Transactional Replication 2005
    ... replication from production database as the publisher and subscribe it to ... Create the distributor on the publisher server ... I then create the subscriber, ... the identity NFR property setting has to match between publisher ...
    (microsoft.public.sqlserver.replication)
  • Re: Sp_adjustpublisheridentityrange and resetting identity range
    ... > identity ranges you have set on your publisher. ... > ranges which will work for the lifetime of their replication solution. ... > should apply this value on the subscriber. ... >> restored the published database from a backup. ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge Repl Failure - Rollback or not
    ... Looking for a SQL Server replication book? ... > Publisher box now shipped to new location. ... > Generate a single insert at subscriber and replicate. ... > Disconnecting from Subscriber 'GENDEV003' ...
    (microsoft.public.sqlserver.replication)
  • Re: Disaster Recovery for Bi-Directional Transactional Replication
    ... With un-directional replication you can have multiple publishers publishing ... If the main publisher went off line a standby publisher could go online and ... subscriber, and then you would be faced with the same question as to what ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Inactive Publisher??????
    ... wondering if you initially setup replication under a low-privileged account ... I then imported data from the publisher to the subscriber so that the ... So I set up my subscriber as the distributor using the wizard. ...
    (microsoft.public.sqlserver.replication)