Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
djorre
Yak Posting Veteran
94 Posts |
 Posted - 2009-06-16 : 11:20:21
|
| Hi Friends,I want to add a column to certain tables, but am refused because 'replication' is on. This is because in the past there was a replication, but that other server crashed and has been removed. I don't know anything about replication or how to put it of so I can add my columns.When I see Replication - Publications - No itemsReplication - Subscriptions - 'oldserver' type: push status: sychronising...How can I remove this without messing up the database please?Is it safe to just use 'newserver' sp_removedbreplication 'newserver'?Because all the sp's I found to remove push subscription need to be executed on Publisher, but the Publisher is not here anymore?Please help. GreetingsJoris |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-16 : 13:00:57
|
| yes.. seems like your replication has some broken components and hasnt been properly removed.. run sp_Removedbreplication on publisher, distributor and subscriber.. it will remove all replication components...Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
djorre
Yak Posting Veteran
94 Posts |
Posted - 2009-06-18 : 09:07:36
|
| I tried to run this sp_removedbreplication but after 25 minutes it was still running and complaints from the area were rolling in (pda clients lost connection, probably because of sql2000 overload). I cancelled it and thank God the pda's worked again. So I got a major problem here adding these colums or removing replication on a subscription server with a crashed publisher. Help! |
|
|
|
|
|
|
remove replication subscription