I'm not sure why my transactional replication is giving me: "The initial snapshot for publication 'XYZ' is not yet available." I have 1 publication going to 3 subscribers on different servers. After creating new subscriptions on Subscriber #3, the subscriptions on Subscriber #1 stopped pulling new data (was running fine for months)
Does re-creating a snapshot at the publisher, to go to a new subscriber have an effect on my long running original subscription ??
I reinitialized the subscription on subscriber #1, re-ran the snapshot at the publisher, then when it finished, I re-ran the subscription pull job. at subscriber #1. It completes normally, but finishes in just a few seconds & does nothing. It seems I have to drop the subscription and re-create it.
Re-generate snapshot and execute it for the subscriber #1. If it does not work, drop & re-create subscription. Then it will work.
We walk in the dark places no others will enterWe stand on the bridge and no one may pass