Thursday, March 8, 2012

Deactivate Subscription status

Hi,
I have a transaction replication b/w two servers. In the publisher's subscription list status,it displays deactivated.
The Replication is stopped because of this, i am not able to change the status.
What to do ? Please let me know.
Kumaran,
Subscriptions can be deactivated or can expire if they are not synchronized within a specified period of time. If this shouldn't have happened then you might want to increase the subscription expiration property of the publication and the maximum transact
ion retention property of the distribution database for the future. For now, you'll need to reinitialize.
HTH,
Paul Ibison

No comments:

Post a Comment