Unable to delete publication - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

Unable to delete publication

Author

Topic

rio.rohit22
Starting Member

11 Posts

Posted - 2010-02-11 : 08:23:42

Hey friends,

I have a default instance running on SQL Server 2005, i had done replication for a database from a production server to backup server but somehow something went wrong, now i need to delete this replication. I have deleted Subscriber successfully. The problem is that i cannot delete Publisher and Distributor from my production server. Whenever i try to delete publisher SQL Server hangs up and users cannot access it, also it never gives any warning massage or any error, I have to do end task to sqlserver.exe.

Please help me

Thanks in advance

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-02-11 : 10:13:53

run this in the publisher db:

sp_droppublication @publication = 'publication'

run this in master of the distribution server:

sp_dropdistributor @no_checks = 1

for more detail
see here: http://support.microsoft.com/kb/324401
and here: http://technet.microsoft.com/en-us/library/ms188363.aspx