How can I recover Merge replication data lost, due to a schema change snapshot being applied?
Posted on 2008-10-01
Using SQL Server 2000
I have a merge replication setup between two offices, I made a change to the article published, but did not generate a new snapshot for two days. Usually I generate and apply it straight away, with no loss of transactions/ data, nor the need for the whole database to be pushed to the subscriber.
However, on this occasion I appear to have had all the data on the subscriber replaced!!
How can I recover the lost merge transactions from the subscriber?
Unfortunately no backup file available :(
Why did this not behave in the 'normal' way where only changes are propagated to the subscribers?