2x SQL2008R2 SP2. (Box 'A' andf 'B')
'A' has a database 'C' which is to be replicated onto 'B'. 'C' has only 8 Articles (4 tables, 4 views).
I set up a Merge-Replication (Publisher and distributor is 'A'), subscriber is 'B'. Snaphot is to be transferred via FTP.
When creating a new pull on 'B', i want to use a new database (selected "new database', 'D'). 'D' should then be initialized with the snapshot which has been generated while creating the publication.
Unfortunately, the snapshot will not be applied to 'D'. The agent just starts to replicate the database. But since the new (empty) database 'D' is missing some tables, i receive an errormessage, that the view cannot be inserted due to missing components.
This is correct since the snapshot was not applied to 'D'. If i prepare 'D' manually to include the tables and views, the replication works fine, data is being copied between 'A' and 'B' and vise-versa.
But setting up a SNAPSHOT-publication for database 'C' on box 'A', then creating a snapshot-pull-subscription for this on box 'B' into 'D' , the snapshot will be applied as expected.
I used the same permissions (SQL-Agent, etc.) for both publications/subscriptions.
Ans hints for troubleshooting ?
Thanks in advance !
View Complete Post