CODEWITHSUNDEEP
sql-serverreplicationmerge-replication
Alexandre_Almeida
Alexandre_Almeida

Reputation: 141

Find deleted row from Merge Replication

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?

Upvotes: 2

Views: 504

Answers (1)

Brandon Williams
Brandon Williams

Reputation: 3765

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.

Upvotes: 1

Related Questions