Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TSharp
Starting Member
9 Posts |
 Posted - 2008-08-12 : 15:51:27
|
| We currently have SQL Server 2000 and have merge replication. We have the following process:1. Data is transfered to a laptop, data on the laptop is changed and the data on the server is 'locked' no changes can be made.2. After a few days, the laptop is returned to the office.3. A script is ran to delete the data on the publisher. Replication works, the subscriber side is updated with the change (no data in the tables). 4. A DTS package is then ran to transfer the data from the laptop to the publisher. Replication does not work at this time, Data exists on the publisher side, but not the subscriber side. The replication monitor detial session does not indicate there are any problems and appears to be running like normal.5. The same DTS package was then ran on the subscriber side to get the data there. This worked.We now run into the following problem when trying to delete a row out of one of the tables. Cannot insert duplicate key row in object "MSmerge_tombstone' with unique index 'uc1MSmerge_tombstone' The statement has been terminated.My first question is why does the replication not work when the DTS package is ran?The second question is, any ideas why we can not delete a row out of the table?ThanksTsharp |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-12 : 22:20:51
|
| For 4, did you see any error in merge agent?For delete, MSmerge_tombstone table contains information on deleted rows and allows deletes to be propagated to other Subscribers. The message you got means that those rows are deleted already already and waiting for replication, you need find out which step did that. Trace them in profiler if necessary. |
 |
|
|
TSharp
Starting Member
9 Posts |
Posted - 2008-08-13 : 11:28:34
|
| Thanks for responding, there were no errors with in merge agent. We also ran Validate all subscritions and did not have any errors. How would I go about doing a trace with in the profiler? (as you can see, I am new to this environment)ThanksTsharp |
|
|
|
TSharp
Starting Member
9 Posts |
Posted - 2008-08-13 : 11:39:09
|
| I found some useful info on the trace profiler, I do not need a response on it... Now the question is, is there anything that can be done to fix this problem, espeically with the msmerge_tombstone file?Tsharp |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-13 : 22:19:40
|
| Take look at sp_mergecleanupmetadata. |
|
|
|
|
|
|
|
|
replication and msMerge_tombstone problems