Is there any way to force SQL Server NOT to mark subscriptions as inactive, ever?
It happens sporadically when there are connection issues and I don't want to have to reinitialize the subscription every time.
Note, I'm not talking about the subscriptions being marked as expired...just as inactive.
We have retention set to 0 (infinite). I'd rather have a big distribution database than have to reinitialize a 15GB database to a subscriber over the WAN. Anyway, the real issue here is that they are getting marked as inactive within just a few hours sometimes...or sometimes a few days...it seems sporadic. Is there any way to tell WHY SQL decided in its wisdom to mark them inactive?