Tuesday, March 27, 2012

cannot drop transactional subscription

My publisher server crashed and will not be coming back. I have to turn one
of the subscribing servers into the new publisher, but it still thinks it's
subscriber to the publisher that crashed.
Documentation says you can only drop the subscriptions from the publisher?
Now what?
JD,
running sp_removedbreplication should remove any remaining references.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Why do you say the subscriber cum publisher still thinks it is the
subscriber? What is the error message you are getting?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"JD" <JD@.discussions.microsoft.com> wrote in message
news:66F31D84-0CEA-49C0-8A5D-970821275954@.microsoft.com...
> My publisher server crashed and will not be coming back. I have to turn
one
> of the subscribing servers into the new publisher, but it still thinks
it's
> subscriber to the publisher that crashed.
> Documentation says you can only drop the subscriptions from the
publisher?
> Now what?
sql

No comments:

Post a Comment