SQL Server Performance

Replication problem in SQL 7.0

Discussion in 'Performance Tuning for SQL Server Replication' started by jvivek2k1, Nov 21, 2006.

  1. jvivek2k1 New Member

    Hi All,

    I have a server named A replicating to other servers. Database 'one1' is invloved in replication for server A. The Database 'one1' is renamed by someone as 'two2' with publication left in it. I have deleted the publication named one1_to_one1 found in renamed database 'two2'. The publication one1_to_one1 in the database 'two2' has got deleted, but iam not able to delete the publication one1_to_one1 from REPLICATION MONITOR's publisher, When i try to delete it the error is like 'one1_to_one1' cannot be found in TRANSPUBLICATION collection.

    Can anyone please help me out. I want to delete the publisher one1_to_one1.
    jvivek2k1, Nov 21, 2006
    #2

  2. dineshasanka Moderator

    try running sp_removedbreplication

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
    dineshasanka, Nov 21, 2006
    #2

  3. MohammedU New Member

    You may need to cleanup the from distribution..mspublications table.

    Mohammed.
    MohammedU, Nov 22, 2006
    #2

  4. jvivek2k1 New Member

    Hi Mohammed,

    Can you please tell me where are these tables located.

    Thanks in advance
    jvivek2k1, Nov 23, 2006
    #2

  5. satya Moderator

    distribution..mspublications - on distributor side

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
    satya, Nov 23, 2006
    #2

  6. dineshasanka Moderator

    rather than try to edit system tables, better first try with sp_removedbreplication, if not you may have to remove records in system tables

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
    dineshasanka, Nov 23, 2006
    #2

Share This Page