Wednesday, March 21, 2012

Reactivating an expired Subscription

Hi all,
One of the subscribers I am managing is displaying a message saying that the
pull subscription has expired although the publication properties on the
publisher is showing that the publication never expires. Is there a way to
"reactivate" the expired subscription without re-initializing it.?
Thanks
It is possible for transactional, but you are best off to drop the
subscription and do a no sync. Then run a validation and determine how out
of sync you are. After you have done this evaluate whether to proceed. You
may want to re-initialize and regenerate and deploy the snapshot. If not,
you might want to run in the continue on data consistency errors profile.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"imad koussa" <imad.koussa@.aims-co.com> wrote in message
news:ud7tR6rvFHA.3124@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> One of the subscribers I am managing is displaying a message saying that
the
> pull subscription has expired although the publication properties on the
> publisher is showing that the publication never expires. Is there a way to
> "reactivate" the expired subscription without re-initializing it.?
> Thanks
>
>

No comments:

Post a Comment