Hi, i had a server that was a publisher/distributor. We decide to change
the server name. When we want to execute the sp_dropserver and
sp_addserver display some errors, so we decided to disable the the
publisher/distributor option. When we did it, the distribution database
wasnt deleted.
Do somebody know if is correct that the distribution database already
exists? Can i delete it manually?
I i try to reconfigure the publisher/distributor options it reports to
me that already exists a database with the distribution name, and i have
to select another name.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Maria,
please have a look at sp_dropdistributiondb and sp_dropdistributor.
HTH
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Monday, March 26, 2012
Problems disabling distributor/publication.
Labels:
andsp_addserver,
changethe,
database,
decide,
disabling,
distributor,
execute,
microsoft,
mysql,
oracle,
publication,
publisher,
server,
sp_dropserver,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment