June 22, 2006 at 9:01 am
Once a subscription has expired (Because I forgot to check "Subscriptions never expire" D'oh ! ) is there a way to "un-expire" the subscription. There must be a flag in a system table somewhere, but I haven't fount it .... Yet ! I'd rather not reinitialize and start from scratch.
Why would you want subscriptions to expire anyway ?
June 22, 2006 at 9:16 am
Subscriptions are set to expire because in case you configure a replication for temporary purpose after which you forgot the remove the subscription then in this case the publisher will expire & drop the subscriptions after the specified days if no activities are recorded for replication, this is to avoid load on the publisher.
------------
Prakash Sawant
http://psawant.blogspot.com
June 22, 2006 at 9:52 am
Thanks ... I guess I'd prefer the default to be "never expire".
It looks as though I have to drop what remains of the subscription & recreate it using the existing data ... I think the expiration process actually deletes information in the systems tables, not just flagging the data.
Thanks anyway.
June 22, 2006 at 9:53 am
might be the status field in mssubscriptions on
distribution database
June 26, 2006 at 12:05 pm
I think once the subscription expires you need to resetup replication from scratch.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply