Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.