SQL Server Performance Forum – Threads Archive

Kill replication

Hi everybody
I am trying to alter table in user database .It have been under
replication. I disable replication(drop subscription
,publishing…restarted services , ect.)It still did not allows me to
alter/rename/drop table and it still showing that the database under
replication..
If anybody aware of the way to update system tables to force the database
drop the replication links? Thanks in advance ,
STAN
STAN

What kind of replication you had established on database(s) that you are trying to remove. check this: – The MSpublisher_databases table contains one row for each Publisher/Publisher database pair serviced by the local Distributor. This table is stored in the distribution database. Column name Data type Description
publisher_id smallint ID of the Publisher.
publisher_db sysname Name of the Publisher database.
id int ID of the row.
Deepak Kumar –An eye for an eye and everyone shall be blind

sp_removedbreplication
Removes all replication objects from a database.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I have some experience to share as I faced the same problem after disabling the replication. I found the existence of a record in MSsubscription_agents. After deleting the record the thing worked. Thanks & Regards.
Arindam Ganguly

Thanks everybody for the help. Due to time limitation It has been resolved with Microsoft help.I belive I going to make my choice toward Log Shipping….
STAN

Review the information in this website about log shipping. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks STAN

]]>