When installing any ConfigMgr update, and you are running replica Management Points, then you need to disable the replication between the site database and replica DB’s before installing the update.
The Microsoft documentation mentions this but glosses over the subject with no real guidance on how this is achieved.
‘Upgrades to System Center Configuration Manager: Before you upgrade a site from System Center 2012 Configuration Manager to System Center Configuration Manager, you must disable database replicas for management points. After your site upgrades, you can reconfigure the database replicas for management points.’
The following blog post takes you though the process from start to finish.
Open up SQL Management Studio on the site database server . Connect to the Database Engine and then navigate to the Replication node in the Object Explorer. Right click and select ‘Disable Publishing and Distribution’.
Select ‘Yes, disable publishing on this server’. Click Next.
Click Next to confirm.
When complete, no publications will exist. At this point you can update or hotfix the ConfigMgr site.
When the site update has completed, then it is time to add the publication back to the ConfigMgr site database and re-subscribe the replica DB’s.
On the site database server open up SQL Management Studio and execute the following SP.
Use CM_<SITECODE> Go exec spCreateMPreplicaPublication
The SQL publication will be re-created.
Connect to the database engine on a replica DB server and navigate to the Replication>Local Subscriptions node. Right click and ‘Delete’ the existing subscription.
After the subscription is removed right click and choose ‘New Subscriptions’
The New Subscription Wizard will appear. Click Next.
Click <Find SQL Server Publisher> from the Publisher drop down.
Connect to the site database server when prompted. The publication will appear. Click Next.
Select replica DB as the subscription DB. Click Next.
Click the dots …
Select to ‘Run under the SQL Service Agent service account’. Click OK then click Next.
Select an appropriate Agent Schedule. I have set ‘Run continuously. Click Next.
Choose ‘At first synchronisation’ and click Next.
Click Finish to complete the subscription set-up.
The subscription will be created. Repeat for all replica DB’s that you have in your environment.