<bourgon@gmail.com> wrote in message
news:1188516568.825970.321490@x35g2000prf.googlegroups.com...
> During a deploy I managed to break a subscription. Obviously the
> answer is to refresh the subscription with a snapshot. The problem
> I'm running into is that these subscriptions are all on a shared
> agent. So I'm getting this error message:
>
> 2007-08-30 23:10:10.947 Agent message code 21074. The subscription(s)
> have been marked inactive and must be reinitialized. NoSync
> subscriptions will need to be dropped and recreated.
>
> Which doesn't tell me which of the subscriptions is broken, just that
> one is broken, which affects all the others on the same shared agent.
>
> I have tried refreshing a couple of the subscriptions from the
> replication monitor, but no dice. I can't do any more of them before
> late tonight.
>
> Any suggestions, anyone? Thanks.
>

On Aug 30, 9:54 pm, "Hilary Cotter" <hilary.cot...@gmail.com> wrote:
> All of them will have expired.