How to Disable SQL replication

If you are running replica MPs, then you will need to disable SQL replication.

Load up SQL Management Studio.

Drill down to Replication, right click and choose ‘Disable Publishing and Distribution’

 Click Next

Select ‘Yes, disable publishing on this server’ and click Next.

Confirm the dropping of replication by clicking Next.

Ensure ‘Disable publishing and distribution’ is checked and click Next.

 Click Finish to disable the replication.

 Click Close to complete the process.

Remember to re-enable replication once the upgrade to 1511 is complete.