Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

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 set of database with merge replicate configured between them.

The publisher is an aggregate of three sets of data. Call them set 0, 1, and 2

There are subscribers that grab one set of the data depending on their geographical region (in SQL terms the HOST_NAME()).

One of the servers was setup with the wrong set. (0 instead of 1). I have corrected the function responsible so that servers should now get the correct set. What do I need to do to force that server to dump its current data and grab the correct set all over again?

Marking the SQL server for a reinitialise from subscription did not do the trick :(

share|improve this question

Please follow the steps in Create a Snapshot for a Merge Publication with Parameterized Filters to generate a new snapshot. You must first generate a standard snapshot, then generate a Subscriber-specific partitioned snapshot. After generating the snapshots, mark the Subscriber for reinitialization and start the Merge Agent to pull down the schema and data for the filtered subscription.

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.