Thursday, March 29, 2012

Endless loop while sync.

I am trying to replicate a database but it seems to go into endless
loop showing:
Processing article: 'Table1'
Processing article: 'Table2'
Processing article: 'Table3'
Processing article: 'Table1'
Processing article: 'Table2'
..
..
..
I stopped it after quite a lot of loop cycles, but it looks like it is
still running in background. In enterprise manager the last action is
"Synchronization in progress" and status is "Running". I already
restarted the sql-server service and also the computer - didn't help.
The replication is done using an external program and not with job.
Thanks
This can be normal. You should let this process finish. It is somewhat
transactional, ie it will pick up where it left off.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"or dromi" <or_dromi@.walla.co.il> wrote in message
news:539934ef.0411240754.37ab924a@.posting.google.c om...
>I am trying to replicate a database but it seems to go into endless
> loop showing:
> Processing article: 'Table1'
> Processing article: 'Table2'
> Processing article: 'Table3'
> Processing article: 'Table1'
> Processing article: 'Table2'
> .
> .
> .
> I stopped it after quite a lot of loop cycles, but it looks like it is
> still running in background. In enterprise manager the last action is
> "Synchronization in progress" and status is "Running". I already
> restarted the sql-server service and also the computer - didn't help.
> The replication is done using an external program and not with job.
>
> Thanks
sql

No comments:

Post a Comment