sql server replication: Reactivating an expired Subscription -- sql server replication

Reactivating an expired Subscription

imad koussa
9/21/2005 12:00:00 AM

sql server replication:

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

Re: Reactivating an expired Subscription

Hilary Cotter
9/21/2005 10:02:02 PM

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
[quoted text, click to view]