Hi all,
I am having a problem now. I cannot drop my publisher and publication because i was uninstalled the remote distibutor before i disable al lthe publication. Now the remote distibutor no longer exist.
Can another one help me? Urgent!!I don't know of any way to remove replication using the GUI tools in the situation you've described, but it can be done fairly easily using Transact SQL stored procedure calls. Check out sp_droppublication (http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_repl2_617y.asp) and pay special attention to the @.ignore_distributor parameter. Microsoft normlly recommends that you use this only with the help of their PSS group, but your data may not be worth $750 to open a support incident with them, so you may choose to "go it alone" instead of calling them for help.
-PatP
Wednesday, March 7, 2012
Publisher cannot be droped becaused Remote Distributor down
Labels:
becaused,
database,
disable,
distibutor,
distributor,
drop,
droped,
lthe,
microsoft,
mysql,
oracle,
publication,
publisher,
remote,
server,
sql,
uninstalled
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment