Saturday, May 3, 2008
Error in replication::subscription(s) have been marked inactive and must be reinitialized
Try the following steps:
1. Select * from MSsubscriptions to locate the expired subscription.
2. Use the query below to reset the status in MSsubscriptions table. Fill in the values for the publisher_id, publisher_db, publication_id, subscriber_id and subscriber_db in the query below with the values from the expired subscription in the MSsubscriptions table.
update distribution..MSsubscriptions set status=2 where publisher_id='x' andpublisher_db='x' and publication_id='x' and subscriber_id='x' and subscriber_db='x'
Status of the subscription:
0 = Inactive
1 = Subscribed
2 = Active
Labels: SQL Information