Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a customer's server which is giving me a "Snapshot not available" error when trying to do it's replication.

From what I've read, I need to mark it for reinitialization.

Now, here's the important part: On the subscribing server, there is information that's being added to the database via a manual interface, that the information on the publishing server (which serves to bring in XML feeds and then publish the inserts to the web server's database) can't overwrite.

So, what I need to know is whether executing the reinitialization will overwrite the subscribing server with the publishing server's copy of the data which does not contain these manual entries? (I'm not the person who set this up, otherwise I would have set it up with the subscriber's updates being propagating back to the publishing server)


share|improve this question

If you are in a situation where you must end up reinitializing and you cannot lose data on the subscriber, then you are going to have to probably generate/script the unsynched changes using tablediff. This sounds like the case if the subscriber is looking for the replication snapshot. After the data is corrected you can blow away and recreate the subsciption.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.