Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Problems setting up new subscriber for merge replication Expand / Collapse
Posted Sunday, January 19, 2014 12:51 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 9:43 AM
Points: 32, Visits: 154

I would like to know the most common way for setting up new subscribers for merge replication. Is it possible to "fill" an empty database on the new subscriber via initializing it with a new snapshot?

I'm having a hard time initializing a new pull-subscription for an existing merge-subscription (2nd Laptop). I always get errors regarding dependent objects. For example a missing table for a view. I understand that SQL-Server should detect these obvious dependencies und create the objects in the appropriate order (what it actually does with an existing subscriber). But it seems to me that's not the case with the new subscriber.

I tried syncing with/without initialization, empty database, restore of publisher-db (without replication-settings), etc. - no luck.

Is simple initializing the Subscriber with an new Snapshot not sufficient? What else has to be done to add a new subscriber?

Many thanks.

Post #1532464
Posted Sunday, January 19, 2014 10:43 PM


Group: General Forum Members
Last Login: Wednesday, May 14, 2014 6:39 PM
Points: 21, Visits: 93
Firstly, make sure the snapshot is up to date on the Publisher. You can right click the publication, view snapshot agent status, and run it from there.

As far as the subscriber goes, the issue is you are trying to run it without initialization. That is telling SQL that the database already exists on the subscriber, and contains the full schema and data. You can only use that option if the database exists already, schema AND data. If it doesn't, choose initialize.
Post #1532498
Posted Monday, January 20, 2014 4:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 15, 2014 11:38 PM
Points: 9, Visits: 73
SQL Server tries to determine the order of the articles, but if it is not working, you may need to set the
@processing_order yourself
Post #1532814
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse