var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Can't remove subscription info
I deleted a replication in the PROD server. However, the subscription info still exists in the subscription folder in the DR server.
Can anyone tells me how to remove the subscription info? (When I delete the publication, there's a message saying we need to manually delete the subscription info in the subscriber)
I'd tried restart the SQLAgent service, Disabling Publishing in PROD server but it's useless.
The subscriber may be not online when u dropped the publication.
Run sp_dropsubscriber at the publisher, see syntax in BOL. If it won't work; manually delete the subscription from the subscriber using Enterprise-Manager.
However, the sp_dropsubscriber won't work, i keep hiting error 14048.
Anyway, my real interest is how to 'manually delete the subscription in EM' as mentioned by you...
At PROD server, publication is drop, there's NO item in Publications & Subscriptions Folder.
At DR server, there's no item in Publications Folder, BUT there's 1 item (subscription) in Subscriptions Folder.
Can you pls provide step-by-step details in how to delete the subscription info using EM?
Simply right click the subscription in the subscriber and choose delete. If u get error; run sp_mergesubscription_cleanup (if u r using merge replication) in the subscription db. It would clear all the subscription info.
Thanks again TALAT,
Extra info: Previously I'm using Transactional Replication. At the Subscriber, in the Subscriptions Folder, it shows 1 item of subscription with the Type: Push
When I right-click on either the Subscriptions Folder or the Subscription itself, there's no Delete option to choose from, this is what bugging me.
Thanks Satya, the link is useful.
What's really bugging me is why there's no simple way to do this in EM?
Sometimes its better to follow system supplied SPs rather than depending upon Lazy GUI tools, as far as my exp. conveys.