I am using transactional replication.
I have 4 subscribers. My publisher and distributor are on the same node. When data is sent to the publisher, the data is automatically sent to the subscribers.
Question to be answered: I want to simulate the following manual action in transact-sQL:
- Reinitializa all subscriotions
with following options checked: use a new snapshot, generate the new snapshot now
- Mark for re-initialization
There are times when my replication fails to some or all subscribers. This seems to be mostly due to network performance. I usually get the following error: The row was not found at the Subscriber when applying the replicated command.
When I execute the manual procedure indicated the error is eliminated and each subscribers gets updated.