conlict resolution question (merge repl)
- From: "djc" <noone@xxxxxxxxxxx>
- Date: Thu, 9 Feb 2006 17:38:00 -0500
windows 2000 / sql 2000
in the conflict resolution dialog I get the 'winner' columns listed with
data and on the right 'loser' side I see this message instead of data:
"The error described above occurred when trying to insert or update this
data at the other server. If you ignore this conflict, you should resolve it
through other means. Consider logging the details of this conflict, then
sending the log entry to your system administrator"
My issue is that the subscriber machine ran out of hard drive space so all
the inserts (and some updates) were failing to get written to the
subscriber. Suprisingly sql server says thats a 'conflict'. I would rather
something like that 'fail' replication so its discovered sooner. Anyway:
1) I want to keep the update that occured at the publisher but I don't know
if thats the 'winner' or 'loser' here? its not clear. The winner side shows
data, and the loser side shows the message I pasted above. I have several of
these and I am not personally familiar with the db data so I can't tell from
looking at the data if its the 'updated' one or not. How do I know? (it sure
would be nice if the interface actually told you which machine's data you
were looking at along with 'winner' or 'loser')
.
- Follow-Ups:
- Re: conlict resolution question (merge repl)
- From: awijnholds
- Re: conlict resolution question (merge repl)
- Prev by Date: Re: SQL 2005 - Identity Range Management
- Next by Date: Re: SQL 2005 - Identity Range Management
- Previous by thread: Publisher and Subscriber on the same SQL Server
- Next by thread: Re: conlict resolution question (merge repl)
- Index(es):
Relevant Pages
|
|
