July 16, 2008 at 12:56 pm
I hope you guys have an answer for me. Here's the scenario:
Transactional Replication with initial Snapshot:
Server1 - Publisher
Push Subscription to Server2
Server2 - Subscriber
Distributor located on this server
We just lost Server2. Lost as in, it crashed and isn't coming back. I obviously need to break/delete replication but it will not let me because it's looking for Server2 and just throws up errors whenever I try to delete the subscriber or publisher.
Please help!!!
July 17, 2008 at 2:03 pm
Take a look at :
sp_removedbreplication @dbname = 'db_name'
* Noel
July 21, 2008 at 8:47 am
noeld (7/17/2008)
Take a look at :
sp_removedbreplication @dbname = 'db_name'
Thanks for this tip ... I just recently came accross a scenario where other means to remove the replicated DB failed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply