2

Merge Replication creates a table named MSmerge_tombstone, it records all deleted rows. My question is, how can i find this deleted row? This row's Data is recorded in any table?

Alexandre_Almeida
  • 131
  • 1
  • 3
  • 10

1 Answers1

1

To track changes, Merge Replication must be able to uniquely identify every row in every published table. To accomplish this Merge Replication adds a rowguid column to every published table.

MSmerge_tombstone contains a column rowguid. The rowguid in MSmerge_tombstone is the rowguid of the row that has been deleted. If a row has been deleted, the actual row data is NOT recorded by Merge Replication. The best way to find the row data would be to grab the rowguid from MSmerge_tombstone and locate the row in a database backup.

Hopefully you have been taking and keeping backups.

Brandon Williams
  • 3,695
  • 16
  • 19
  • I'm still doing some tests in my database whit replication, I have a backup but I'm not using it for now. I had this doubt after read that MSmerge_tombstone record deleted rows. Thank you – Alexandre_Almeida May 11 '15 at 13:20