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
Saturday, May 3, 2008
Error in replication::subscription(s) have been marked inactive and must be reinitialized
Labels:
SQL Information
Subscribe to:
Post Comments (Atom)
8 comments:
Thanks for this tip, you saved my skin!
great trick!
super tip... thank u very much segu...
supr
hoe yo find published atricles in Publisher
one of my article is not sinking with subscriber.How to find that
Kindly send your error message to my email ID. sandeshsegu@SansSQL.com
Awesome and interesting article. Great things you've always shared with us. Thanks. error 502 bad gateway fix
Post a Comment