Replication Topology: Server A(pub)---->Server B(distributor)-----> Server C(subscriber)(Re-publisher)------->Server B(distributor)-------> Server D(subscriber)
1. Need to re-initialize Subscription once every weekend. This subscription is being re-Published.
I need to Uncheck all articles from republished database(subscription db before applying snapshot). I plan on running this as a Script under the Before Applying Snapshot. Please advise how this can be achieved.
1.Tried reinitialising the pub(server A) , replication had errors, could not delete table on subscriber as it was being used in replication
2.Tried setting table properties and setting action if name is in use : to keep existing object unchanged..still received repl errors.
3.Finally, the removing the tables from Republication seemed to solve the problem. Please advise. thanks.
View Complete Post