SQL Server Performance

removing Distribution without DELETEING

Discussion in 'Performance Tuning for SQL Server Replication' started by eramgarden, May 5, 2004.

  1. eramgarden New Member

    I have a transactional/ Push subscription. Publisher is on one server. Distributor/subscriber on another.<br /><br />I right click on Replication on Publisher database and it gives me a pop-up with the name of the distributor,subscriber . ALL is fine so far.<br /><br />Is there anyway to drop the Publisher's reference to this Distributor WITHOUT actually deleting/removing the distributor database with sp_dropdistributor/sp_dropdistributiondb ? because I want the Publisher to reference a new distributor. ( hi Satya <img src='/community/emoticons/emotion-1.gif' alt=':)' /> )
  2. Luis Martin Moderator

    I'm not Satya, so you have to wait for expert.
    What I find in BOL is:

    Remarks
    sp_dropdistributor is used in all types of replication.

    If other Publisher or distribution objects exist on the server, sp_dropdistributor fails unless @no_checks is set to 1.

    This stored procedure must be executed after dropping the distribution database by executing sp_dropdistributiondb.


    HTH

    Luis Martin
    Moderator
    SQL-Server-Performance.com

  3. eramgarden New Member

    Thanks Luis- I saw that in BOL but i dont want to "delete" the distribution server because I'm affraid I wouldnt be able to point it to the NEW distributor...I want to keep the CURRENT distributor database just in case ...

    There has to be a way to make the Publisher point to a new/different Distributor without deleting an exsisting distributor...I think..
  4. satya Moderator

    Hi Camilla, hope doing well apart from replication issues.
    As usual BOL specifies, I never tried the other way without dropping current one.

    (Thanks Luis)

    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.

Share This Page