How to disable/enable SQL Replication and remove publishers for SQL Replication

Version 2

    Verified Product Versions

    LANDESK Management Suite 9.6

    Description: This is an walk through on disabling and enabling SQL Replication when working with Rollup cores in 9.6. Note: How this works on a SQL Cluster may be different.

     

    Right-click Replication

     

    Replication1.png

    Select "Disable Publishing and Distribution"

     

    Replication2.png

     

    Select "Yes, disable publishing on this server"

     

    Replication3.png

     

    On the next screen you select the publications that you want to be dropped. Followed by a screen (below) to confirm disabling.

     

    Replication4.png

     

     

    Enabling Replication:

     

    Note: Replication needs to be installed as an option from the SQL setup application

     

    Right-click "Configure Distribution"

     

    Replication5.png

     

    An option will be displayed to choose where the distribution database will be stored. This is usually local to the SQL Server in question and will require a share to be configured as the Rollup/Replication installation document discusses:

     

    Replication6.png

     

    Replication7.png

     

    Two more confirmation screens on options for distribution are displayed. Before the final option below. Configuration of replication when then begin.

     

    Replication8.png

     

    Replication9.png