Groups | Blog | Home
all groups > sql server replication > march 2006 >

sql server replication : sql server2005 replication stops after a period of time


Hilary Cotter
3/21/2006 10:49:28 PM
Is there any DML going on on the publisher? How is the db updated? Note that
by default any DML occurring through DTS, bcp, or SSIS will not be merged.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



[quoted text, click to view]

Zrod
3/21/2006 11:23:30 PM
Hi,
I have set up a merge replication on a sql server 2005 developer edition.
i've notice after a period of tiome (aprox 10 days) that records are not
replcated anymore.
the replkication monitor shows that no records need to be merged.
note that update is done mainly on the publisher
Any hint?
Tnahs in Advance

Zrod
3/22/2006 12:00:00 AM
Update is done through an ERP Application.
Note that same type of updates was used on SQL2000 and Everything was
Normal.

[quoted text, click to view]

AddThis Social Bookmark Button