Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / February 2006

Tip: Looking for answers? Try searching our database.

Merge Replication Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sam - 23 Feb 2006 07:02 GMT
Hello

I have merge Replication MSSQL Server 2000 SP4, One Publisher and 5
subscribers,

a)      Subscribers1 has inserted the record at 8 AM and Send it to
subscribers2 & subscribers3

b)      Using DTS, but not insert directly subscribers2 DB its Inserted
TempDB to subscribers2 DB using Store procedure.

c)      Subscribers2 users update same records at 3 PM. It means now other
Subscribers not update those records.

d)      I changed my article
@property='compensate_for_errors',@value='false'.

e)      I have facing  some conflict Problems

f)        After Synchronization  those records was deleted at some
Subscriber

g)      We are Synchronization at 1 AM. For Schedule bases

Here the Question.

Why the Data going to deleted?

Which data going to Synchronies in above case?

Suppose I update row 1 following time

Subscribers1 at 6 am

Subscribers1 at 7 am

Subscribers1 at 8 am

Subscribers1 at 9 am

Subscribers1 at 11 am

Which data going to Synchronies in above case?

       Please Explaning Clearly

Thanks

Sam
Hilary Cotter - 23 Feb 2006 13:08 GMT
Sam I am having problems understanding the scenario you present. Before I
start guessing at what happened I want to explain a couple of things.

a) compensate_for_errors - this switch means that if a conflict occurs the
data will not be wiped out on the conflict loser. For example if a row with
the same PK value is simultaneously inserted on the publisher and subscriber
and the compensate_for_errors switch is set to true (true is default for SQL
2000, false is the default for SQL 2005) the row on the subscriber will be
deleted and replaced with the row from the publisher. If the
compensate_for_errors setting is set to false, the row on the subscriber
will not be deleted  - in other words - the subscribers row will remain.
With this setting all such compensating actions will not occur.

b) when you use DTS with the defaults the rows dts'd into the table are not
logged and will not be replicated. Consult
http://support.microsoft.com/kb/275680/en-us for more information.

c) exactly what do you mean by "Using DTS, but not insert directly
subscribers2 DB its Inserted  TempDB to subscribers2 DB using Store
procedure." If you mean it was DTS'd to tempdb and then from tempdb to the
subscriber2 db, this should have been logged and any inserts or other DML as
a result of this action should be replicated.

d) did you run conflict viewer for a window into what is happening?

It sounds like what happened what that in step b the rows were not logged
and hence never made it to subscriber 1 and subscriber 3. I don't understand
what happened in f). The conflict viewer should have a record of what
happened.

To answer your questions - data should not be deleted with the
compensate_for_errors setting set to false - only true.

From what you describe in the below scenario, if you are updating the same
row the update should flow with each synchronization unless you are doing
column level tracking - this would be logged as a conflict and the conflict
winner should win the conflict - ie its data should make it to all the
subscribers.

If the sync doesn't happen each hour, only the final result will travel. For
example if the sync runs at 11 am, only the final 11 am change will move.

HTH
Signature

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

> Hello
>
[quoted text clipped - 45 lines]
>
> Sam
Sam - 27 Feb 2006 05:07 GMT
THANKS Hilary
I need to test , let Contact You.
Sam
> Sam I am having problems understanding the scenario you present. Before I
> start guessing at what happened I want to explain a couple of things.
[quoted text clipped - 90 lines]
>>
>> Sam
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.