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 |
|
dyckwal
Yak Posting Veteran
58 Posts |
 Posted - 2009-12-28 : 04:36:13
|
| Hello,I have a publication/subscription that I cannot delete. Whenever I give command to delete this the distribution.LDF file starts growing until the disk is full (from 2048 KB up to 200 GB !)I've tried deleting via the SSMS, via the script (sp_dropmergsubscription, sp_dropmergepublication) but nothing seems to work. It takes all day (more then 8 hours and at the end it hangs, nothing happens. We needed to reboot the server a few times to stop the delete and free up disk space.My question now :Can i just delete this distribution database and manually clean up the rest ?If so what/where do I need to clean up then .Been already working on this for a week and meanwhile we do not have replication for our data, and this is becoming an security issue ..Any tips/help is welcome |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-12-28 : 11:34:16
|
| Try the procs - sp_Removedbreplication and sp_Removedistpublisherdbreplication.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
dyckwal
Yak Posting Veteran
58 Posts |
Posted - 2009-12-29 : 07:52:14
|
| THX dinakar,this did the trick. But now I have another problem.When I try to setup new replication, get errors on missing SP at the distribution DB. So I still cannot setup the replication again.Do you have any hints ?thx |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-12-29 : 16:04:27
|
| I would try removing the distribution database and reconfiguring everything again so you know you are sure there are absolutely no leftovers from previous installations.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-29 : 17:36:21
|
| I have modified the tables in the distribution db when regular methods fail.If you have many publications, removing the distribution db is not a very palatable option. |
|
|
|
dyckwal
Yak Posting Veteran
58 Posts |
Posted - 2010-01-07 : 10:40:19
|
| Thank you all for you're comments.Greatly appriciated |
|
|
|
|
|
|
Unable to remove a replication