SQL Server Performance

Replication from SQL 2k5 to SQL 2K

Discussion in 'SQL Server 2005 Replication' started by WingSzeto, Apr 30, 2007.

  1. WingSzeto Member

    I am setting up a push transactional replication from SQL 2K5 to SQL 2K and after the first try, it created an entry in the foler path of the SQL 2K EM: Replication -> Subscriptions. Now I want to re-do everything again so I did the delete subscription from the SQL 2K5 server. However, the entry of the subscription still exists in SQL 2K as mentioned in the above path of the EM. How do I delete that entry in SQL 2K?

    wingman
  2. MohammedU New Member

    I believe it got created when you configured the server as subscriber...
    If you deleted the subscription, you should not see any subscriptions in that folder...
    If you don't have any subscriptions it should be fine but if you want to delete the folder, remove server as subscriber in the replication configuration...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. satya Moderator

    See this KBAhttp://support.microsoft.com/kb/324401 for manual removal of specific replication.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page