SQL 2005 replcation job for subscriber has been deleted on publication server
Posted on 2009-04-05
Sorry if my terminology is rough. SQL replication is not my expertise.
I have a site lets call it SITE 1 and it has a merge publication db setup on it.
SITE 2 and SITE 3 are the subcriber db's for the merge publication set.
SITE 3's SQL replication job has been deleted from the SITE 1 publication server. This happend about 25 days ago, therefore no merge replication has occured between SITE 3 -> SITE 1 for 25 days.
Replication between SITE 2 -> SITE 1 is working fine.
Is there an easy way I can reconfigue or intialise replcation between SITE 3 -> SITE 1 without causing any data issues with SITE 1 and SITE 2 db's. Essentially I need all SITES to be consistent with with one another again.