Saturday, May 3, 2008

Error in replication::subscription(s) have been marked inactive and must be reinitialized

Whenever there is an error as mentioned above then, you can try to update the status column in the MSsubscriptions table in the distribution database. The status column for the expired subscription indicated a value of 0 meaning inactive. The value of 2 in the status column means Active.

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

8 comments:

  1. Thanks for this tip, you saved my skin!

    ReplyDelete
  2. super tip... thank u very much segu...

    ReplyDelete
  3. hoe yo find published atricles in Publisher

    ReplyDelete
  4. one of my article is not sinking with subscriber.How to find that

    ReplyDelete
  5. Kindly send your error message to my email ID. sandeshsegu@SansSQL.com

    ReplyDelete
  6. Awesome and interesting article. Great things you've always shared with us. Thanks. error 502 bad gateway fix

    ReplyDelete