Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

How can I recover Merge replication data lost, due to a schema change snapshot being applied?

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!!
Firstly -
         How can I recover the lost merge transactions from the subscriber?
         Unfortunately no backup file available :(
Finally -
         Why did this not behave in the 'normal' way where only changes are propagated to the subscribers?
0
debrafry
Asked:
debrafry
  • 2
  • 2
1 Solution
 
debrafryAuthor Commented:
I have found a way of recovering the data. But still don't know why it behaved in this manner.

I downloaded a program called SQL Log rescue by reg-gate.

I was able to read the transaction log and generate a script file that could be run to redo the inserts.  I have had to edit to script file and run it in batches, but on the whole, I have recovered most if not all of the lost data.
0
 
Eugene ZCommented:
did you check: you need to
 How to troubleshoot SQL Server merge replication problems
http://support.microsoft.com/kb/315521
 
--- can be some conflict:
Merge Replication Conflict Detection and Resolution
http://msdn.microsoft.com/en-us/library/aa256310(SQL.80).aspx 
0
 
debrafryAuthor Commented:
Thank you for taking the time to reply, however, this does not answer my question :(.

I have now manged to recover the data. Which was my main problem.

Please close this question.
0
 
Eugene ZCommented:
please contact the EE help to close the post
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now