Monday, March 19, 2012

Data deleted from database

Hi,
I have a merge replication set on a database.
day before yesterday I inserted some 10000 records in a table being
replicated.
The records did get insterted successfully but next day morning when I
checked I found that those records are not present in that table.
I checked all possible ways, data could have deleted but I don't find any
thing.
I see that those records are there in the conflic table because they could
not get replicated because of identity calumn. But that should not delete
records from the table.
I 'm confused and need help.
Thanks
Sam
Hi
Are you sure they were commited? You might have inserted them, looked at the
data, and when you closed the connection, the data got rolled back.
Regards
Mike
"Sam" wrote:

> Hi,
> I have a merge replication set on a database.
> day before yesterday I inserted some 10000 records in a table being
> replicated.
> The records did get insterted successfully but next day morning when I
> checked I found that those records are not present in that table.
> I checked all possible ways, data could have deleted but I don't find any
> thing.
> I see that those records are there in the conflic table because they could
> not get replicated because of identity calumn. But that should not delete
> records from the table.
> I 'm confused and need help.
> Thanks
> Sam
>
>
|||I can say that they were committed because out of 8 table's data I inserted,
4 tables kept the data and 4 did not.
And those 4 who did not keep the data sill have the same records in their
respective conflict tables because of the identity issue.
I don't understand this behaviour.
Please help
Sam
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:7CA4AF30-B285-4463-9142-83DE6233515E@.microsoft.com...[vbcol=seagreen]
> Hi
> Are you sure they were commited? You might have inserted them, looked at
> the
> data, and when you closed the connection, the data got rolled back.
> Regards
> Mike
> "Sam" wrote:

No comments:

Post a Comment