September 17, 2012 at 6:52 pm
I am try to do Distribution_DB on different server.
1) The Issue was there already Distribution_DB configured for the publisher server.
2) I was not allowing me to delete the Distribution_DB on the Distribution server. It throws an errror
"The distribution database 'distribution_DB' cannot be deleted until all Publishers using this distribution database have been disabled"
But they are no Publication really exists. (Checked Ms publication)
3)WHen I execute the below SP on publisher. I get the below info, How could I delete that row below?
sp_get_distributor:
installed |distribution server |distribution db installed |is distribution publisher| has remote distribution publisher
0 NULL 0 0 0
4) I am confused, Does the publisher is thinking it as an distributor is configured?
Any help is greatly thankful.
September 17, 2012 at 7:50 pm
If you execute sp_helpdistpublisher at the distributor, it should return a list of any publishers currently configured to use the distributor.
Then you can force dropping of the publisher with:
EXEC sp_dropdistpublisher 'publisher', no_checks , ignore_distributor
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply