I have a database called reference that exists on server A and server B. Both server A and B are publishers and both are their own distributors. Certain articles are replicated (push) from the reference database on server A to server B and certain
articles are replicated (push) from the reference database on server B to server A. I recently had to restore the reference database on server B with a backup from server A (here is where my problems started). I deleted the existing server A subscription
from the server B publication and then deleted the server B publication, after that I rebuilt the server B publication and added the server A as a subscriber. When I generated a snapshot of the server B publication the subscription will not recognize
the snapshot and continues to say that the snapshot has not been fully generated (yes I verified that the snapshot was fully generated) at this point I even tried to reinitialize the subscription with a new snapshot and I netted the same result.
I then deleted the server B subscription to the server A publication and then deleted the server A publication and then took a backup of server A reference database restored it on server B and ran through the same steps in paragraph 1 with the same result.
I have tried, sp_replrestart, sp_replflush, sp_removedbreplication 'reference', 'tran' an
View Complete Post