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.
Disabling replication
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’.
Click Next
Select ‘Yes, disable publishing on this server’. Click Next.
Click Next to confirm.
Click Next
Click Finish.
When complete, no publications will exist. At this point you can update or hotfix the ConfigMgr site.
Re-enable replication
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.
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 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.
Hi Paul,
I don’t see disable publishing option.
Are you using replica Management Points?
Reblogged this on Configuration Manager Administrator.
Publish something that is your own otherwise you are just a copy cat!