|
Home > Archive > MS SQL Server Replication > November 2006 > help needed on merge replication
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
help needed on merge replication
|
|
| green hand 2006-11-24, 7:13 pm |
| i have a merge replication. it runs well, the subscriber disconnect from the
publisher about 5 days, then i reconnect it to publisher. theoretically
speaking, the changes made during these 5 days made on both publisher and
subscriber will merge into one copy. but customer complain about data missing
on the subscriber. I run Red Gate data compare on publisher and subscriber
database, and find there are different records, missing records and
additional records. Any one know why this happened, and what is the way to
synchronize?
Thanks a lot.
| |
| Mahesh [MSFT] 2006-11-24, 7:13 pm |
| Has the merge agent been run after the 5 days of disconnect?
Hope that helps
--Mahesh
[ This posting is provided "as is" with no warranties and confers no
rights. ]
"green hand" <green hand@discussions.microsoft.com> wrote in message
news:017EBCEF-416D-4300-A792- 843BCC26C4A0@microso
ft.com...
>i have a merge replication. it runs well, the subscriber disconnect from
>the
> publisher about 5 days, then i reconnect it to publisher. theoretically
> speaking, the changes made during these 5 days made on both publisher and
> subscriber will merge into one copy. but customer complain about data
> missing
> on the subscriber. I run Red Gate data compare on publisher and subscriber
> database, and find there are different records, missing records and
> additional records. Any one know why this happened, and what is the way to
> synchronize?
> Thanks a lot.
| |
| green hand 2006-11-25, 12:13 am |
| Thanks Mahesh.
The problem is the merge agent was restarted after the 5 days of
discounnect. And has been alway connected till now.
"Mahesh [MSFT]" wrote:
> Has the merge agent been run after the 5 days of disconnect?
>
> Hope that helps
> --Mahesh
>
> [ This posting is provided "as is" with no warranties and confers no
> rights. ]
> "green hand" <green hand@discussions.microsoft.com> wrote in message
> news:017EBCEF-416D-4300-A792- 843BCC26C4A0@microso
ft.com...
>
>
>
| |
| Mahesh [MSFT] 2006-11-25, 5:13 am |
| Is the merge agent failing or succeeding?
Hope that helps
--Mahesh
[ This posting is provided "as is" with no warranties and confers no
rights. ]
"green hand" < greenhand@discussion
s.microsoft.com> wrote in message
news:A0E71256-C581-45A3-A888- 8E181D4D6A7E@microso
ft.com...[color=darkred]
> Thanks Mahesh.
>
> The problem is the merge agent was restarted after the 5 days of
> discounnect. And has been alway connected till now.
>
> "Mahesh [MSFT]" wrote:
>
| |
| Hilary Cotter 2006-11-25, 7:13 pm |
| Check to see if there are conflicts in the conflict viewer. Also check to
see if you have compenstate_for_erro
rs set to false. This setting will not
resolve some conflicts, but rather leave dml which originates on the
conflict loser in place. For example a pk violation will not be resolved
with the winning publisher's pk value, but the subscriber's one.
--
Hilary Cotter
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
"green hand" <green hand@discussions.microsoft.com> wrote in message
news:017EBCEF-416D-4300-A792- 843BCC26C4A0@microso
ft.com...
>i have a merge replication. it runs well, the subscriber disconnect from
>the
> publisher about 5 days, then i reconnect it to publisher. theoretically
> speaking, the changes made during these 5 days made on both publisher and
> subscriber will merge into one copy. but customer complain about data
> missing
> on the subscriber. I run Red Gate data compare on publisher and subscriber
> database, and find there are different records, missing records and
> additional records. Any one know why this happened, and what is the way to
> synchronize?
> Thanks a lot.
| |
| green hand 2006-11-25, 7:13 pm |
| Thanks Hilary,
I checked the conflict viewer, there is a conflict and the publish win. Does
these explain the data inconsistence between publisher and discriber? I
failed to find where compenstate_for_erro
rs is, for I am an new DBA, could u
give me some hint? should I set it to false or true?
"Hilary Cotter" wrote:
> Check to see if there are conflicts in the conflict viewer. Also check to
> see if you have compenstate_for_erro
rs set to false. This setting will not
> resolve some conflicts, but rather leave dml which originates on the
> conflict loser in place. For example a pk violation will not be resolved
> with the winning publisher's pk value, but the subscriber's one.
>
> --
> Hilary Cotter
>
> 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
>
>
>
> "green hand" <green hand@discussions.microsoft.com> wrote in message
> news:017EBCEF-416D-4300-A792- 843BCC26C4A0@microso
ft.com...
>
>
>
| |
| Hilary Cotter 2006-11-26, 12:13 am |
| It might. If compenstate for errors is set to true all databases will be
consistent. If not they won't. The compenstate for errors parameter is part
of sp_addmergearticle. Use sp_helpmergearticle to verify if this is set to
true or false.
Also consult http://support.microsoft.com/kb/828637 for more info.
--
Hilary Cotter
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
"green hand" < greenhand@discussion
s.microsoft.com> wrote in message
news:8CB5F530-B61D-404B-AC8B- 3888509B13CE@microso
ft.com...[color=darkred]
> Thanks Hilary,
>
> I checked the conflict viewer, there is a conflict and the publish win.
> Does
> these explain the data inconsistence between publisher and discriber? I
> failed to find where compenstate_for_erro
rs is, for I am an new DBA, could
> u
> give me some hint? should I set it to false or true?
>
> "Hilary Cotter" wrote:
>
| |
| green hand 2006-11-27, 12:15 am |
| Hilary,
Thanks very much for help!
I found compensate_for_error
s in a property of sp4. currently the publisher
and two subscribes are all under sp3. It seams the only way is to apply sp4
on all the 3 box. and then set it to ture. Am I right?
Thanks
"Hilary Cotter" wrote:
> It might. If compenstate for errors is set to true all databases will be
> consistent. If not they won't. The compenstate for errors parameter is part
> of sp_addmergearticle. Use sp_helpmergearticle to verify if this is set to
> true or false.
>
> Also consult http://support.microsoft.com/kb/828637 for more info.
>
> --
> Hilary Cotter
>
> 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
>
>
>
> "green hand" < greenhand@discussion
s.microsoft.com> wrote in message
> news:8CB5F530-B61D-404B-AC8B- 3888509B13CE@microso
ft.com...
>
>
>
| |
| Hilary Cotter 2006-11-27, 7:17 pm |
| That is correct.
--
Hilary Cotter
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
"green hand" < greenhand@discussion
s.microsoft.com> wrote in message
news:A5E1B1DF-36A1-43FD-8F7A- 87B46CB2E66A@microso
ft.com...[color=darkred]
> Hilary,
>
> Thanks very much for help!
>
> I found compensate_for_error
s in a property of sp4. currently the
> publisher
> and two subscribes are all under sp3. It seams the only way is to apply
> sp4
> on all the 3 box. and then set it to ture. Am I right?
>
> Thanks
>
> "Hilary Cotter" wrote:
>
|
|
|
|
|