SQL Server Performance

Kill replication

Discussion in 'Performance Tuning for SQL Server Replication' started by mettro, May 27, 2005.

  1. mettro New Member


    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
  2. deepakontheweb New Member


    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
  3. satya Moderator

    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.
  4. 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
  5. mettro New Member

    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
  6. satya Moderator

    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.
  7. mettro New Member

    Thanks

    STAN

Share This Page