Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Unexpected Data Loss(Mege Replication)

 
   Database Help (Home) -> Replication RSS
Next:  Merge replication betwen 2005 standar and 2005 CE  
Author Message
Grigoris Tsolakidis

External


Since: Jan 24, 2008
Posts: 10



(Msg. 1) Posted: Thu Jan 24, 2008 3:58 pm
Post subject: Unexpected Data Loss(Mege Replication)
Archived from groups: microsoft>public>sqlserver>replication (more info?)

I have a replication with SQL Server 2000 with Service Pack 4
Recently i make a freqently update to a table (lets say to update 50000 Row)
2,3 times a day.
After that i notice strange data loss in this table - for example I loose 1
row from 1000 Inserted.
And this rows are not in the conflict table...

 >> Stay informed about: Unexpected Data Loss(Mege Replication) 
Back to top
Login to vote
Hilary Cotter

External


Since: Jan 16, 2008
Posts: 142



(Msg. 2) Posted: Thu Jan 24, 2008 3:58 pm
Post subject: Re: Unexpected Data Loss(Mege Replication) [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

This will be hard to diagnose and trouble shoot. I take it you are not
doing any filtering.

If so make sure the missing rows aren't being filtered out. If not you
will have to run profiler and filter on the replication agent name.

Then see if the rows make it to the subscriber. If not, check
msmerge_contents to see if they were marked for replication on the
publisher.
On Jan 24, 8:58 am, "Grigoris Tsolakidis"
<gcholakidis RemoveThis @spam_remove.hotmail.com> wrote:
> I have a replication with SQL Server 2000 with Service Pack 4
> Recently i make a freqently update to a table (lets say to update 50000 Row)
> 2,3 times a day.
> After that i notice strange data loss in this table - for example I loose 1
> row from 1000 Inserted.
> And this rows are not in the conflict table...

 >> Stay informed about: Unexpected Data Loss(Mege Replication) 
Back to top
Login to vote
Grigoris Tsolakidis

External


Since: Jan 24, 2008
Posts: 10



(Msg. 3) Posted: Fri Jan 25, 2008 10:46 am
Post subject: Re: Unexpected Data Loss(Mege Replication) [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Yes I know this will be hard to track...
I just post it in case somebody else expirence the same problem...
This rows are insert at the subscriber and never apear on the publisher
so i suppose i will not find them in msmerge_contents in the publisher.
(they also desapear from subscriber after a while)
Also i have a strange behavior - lets say that I insert 500 rows in this
table
1,2,3...500. The conection speed is slow so some times i see that the row 3
is comming to
publisher before the row 2 ...

? "Hilary Cotter" <hilary.cotter.TakeThisOut@gmail.com> ?????? ??? ??????
news:f462bab1-9ce5-49b7-83cb-2dd4e6aefb13@m34g2000hsb.googlegroups.com...
This will be hard to diagnose and trouble shoot. I take it you are not
doing any filtering.

If so make sure the missing rows aren't being filtered out. If not you
will have to run profiler and filter on the replication agent name.

Then see if the rows make it to the subscriber. If not, check
msmerge_contents to see if they were marked for replication on the
publisher.
On Jan 24, 8:58 am, "Grigoris Tsolakidis"
<gcholakidis.TakeThisOut@spam_remove.hotmail.com> wrote:
> I have a replication with SQL Server 2000 with Service Pack 4
> Recently i make a freqently update to a table (lets say to update 50000
> Row)
> 2,3 times a day.
> After that i notice strange data loss in this table - for example I loose
> 1
> row from 1000 Inserted.
> And this rows are not in the conflict table...
 >> Stay informed about: Unexpected Data Loss(Mege Replication) 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SSIS / dtsx data replication? - I use a number of SSIS dtsx scripts to perform daily imports. This data isn't getting replication. It appears that this utility doesn't "trigger" the replication of this new data. Is there a switch to manually edit the command to force th...

How to determine size of replication data sets? - Hello - I apologize up front for being unfamiliar with SQL, especially in any of it's replication methods. I have been asked to determine what the rate of data change is, or more clearly, what is the size of data that is being replicated throughout..

Missing data problem with merge replication - 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..

Data Replication Options (SQL Server 2005) - We have a database approx 200 GB size. Approx 5-10 GB of data is modified on nightly basis (delete + bulk load) - no updates. Regarding bulk load, we use simple recovery mode. We want to have another server as a warm/cold backup (and read only ..

Merged replication question with regard to data transfer - Hi, We have an existing merged replication schema that works well. I have added Status screen and an audit table. The status screen's underlying table is status table. The above two articles have been created using a new publication. This publication...
   Database Help (Home) -> Replication All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]