We set up an SQL Server 2012 Replication:
+ merge replication
+ push Subscriber (notebooks)
+ retention period 14-days
After some days (less then 14 days) one of the subscriber (notebook) can't replicate anymore. A review showed the following:
The subscription on the notebook has disappeared. An error message regarding this issue can't be found in the log.
We set up the replicate again and set the retention expiration (setting publication) up to 90-days. Deactivating the cleanup jobs regarding subscriber and distribution and testing again.
Result: The replication works fine for a few days. After a certain time (a few days) the subscription on the notebook has dissapeared again.
Maybe someone has a hint? Which other influences (except expiration time and cleanupjobs) are responsible for deleting a subscriber on the Notebook-side.
Thanks in advance (and please excuse my bad English)
Udo
Subscription disappears
July 30th, 2015 9:52am
Did you have automatic task that delete subscription
Free Windows Admin Tool Kit Click here and download it now
July 31st, 2015 8:08am
Hi Udo
Subscription can become invisible only when your subscriber is expire. Please set subscriber expire property to never.
Please your cleanup jobs might be disabe but wat abt there schedules? if schedule is enable it can trigger disable job se times. so check job history and relication history
August 6th, 2015 3:09am