Post reply

Replication issue : Subscription gets added automatically

  • April 6, 2011 at 10:56 pm

    #234407

    Hello Friends ,

    We are facing some weired issues with 2 of our publications .

    Issue : If we add any new article to our exisiting publication and re-ran the snapshot one subscription which was deleted few months ago gets added automatically . We have other publication which has same subscriptions too .

    Observation : It is not happening with all publication for the same database .

    Please help us out if you have any past expereince similar to this or any trick to fix this . I am suspecting its storing the subscription information in some table which is the speicific one for this which I am not able to figure out .

  • April 16, 2011 at 4:18 am

    #1312427

    It sounds like there is some metadata remaining in your database which needs cleaning up.

    You can try these.

    sp_dropsubscription and sp_subscription_cleanup. If these arent working for you, you will likely have to trawl to the system tables on the publisher, subscriber and distributer.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply