Missing data problem with merge replication
- From: kevin@xxxxxxxx
- Date: Wed, 16 Apr 2008 14:41:21 -0700 (PDT)
Hi,
The scenario I am running into is as follows:
On Sunday the 13th, I attempted to move the publisher to a new server.
Everything looked good except that data changes on the subscriber
weren't be replicated back to the publisher. I undid the server move
and tried to renable the old server. Everything seemed to be ok in
that data was sent back and forth between the publisher and server.
On Monday I received some phone calls indicating that the users were
getting some Invalid Object Type message which meant that there were
still some triggers left around from the failed move. It took a couple
of days but I was able to eliminate the Object Type errors by manually
deleting the triggers and adding views where appropriate.
It now looks like some of the data isn't syncing between the
subscriber and the publisher. I've tried running
sp_resyncmergesubscription but that didnt' seem to to anything. The
weird thing is that it is only occuring on some of the 99 articles in
the publication.
Any ideas?
Thanks,
Kevin
.
- Follow-Ups:
- Re: Missing data problem with merge replication
- From: Paul Ibison
- Re: Missing data problem with merge replication
- From: kevin
- Re: Missing data problem with merge replication
- Prev by Date: SQL 2005 Merge Snapshot Error
- Next by Date: Replication Snapshot using all the memory.
- Previous by thread: SQL 2005 Merge Snapshot Error
- Next by thread: Re: Missing data problem with merge replication
- Index(es):
Relevant Pages
|
