Below is the guide that I normally use for a service pack upgrade in a single primary site environment. I will not go into the story about what files you should download as that is already explained by Jason Sandys here - http://blog.configmgrftw.com/service-pack-madness/
- Back up the SQL Server database and restore a copy of the database on an instance that is not hosting the production database.
- Perform a test upgrade of the database to SP1. The test upgrade must be performed on the database copy.
- Download the ConfigMgr SP1 prerequisite files.
- Disable management point replicas if they exist.
- Run the SP1 prerequisite checker tool and verify that all prerequisites are installed and configured correctly.
- Update boot images.
- Modify task sequences to include the new ConfigMgr client package.
- On your site server, start SQL Server Management Studio.
- Restore the most recent backup of the database.
- In SQL Management Studio, right click Databases and select Restore Database.
- Select Device, click on the Browse button and click Add to select the .bak file
- On the Files tab select Relocate all files to folder and click OK.
- Navigate to ….\SMSSETUP\BIN\X64 and type Setup.exe /testdbupgrade cm_SR1 (notice that if you are not using the default instance you have to type instancename\db).
- Click Begin TestDBUpgrade and accept the database size warning message.
- ConfigMgr will display a final warning message before starting the process. Click Yes and accept the warning.
- After a successful upgrade you will see a line in ConfigMgrSetup.log saying “Configuration Manager Setup has successfully upgraded the database.”
- In the ConfigMgr console, Administration, Site Configuration, Servers and Site System Roles. Open the management point properties and configure all management points to use the site database.
- Open SQL Management Studio and connect to the SQL server hosting the replica databases.
- Select Replication, Local subscriptions. Right click the replica and select Delete. When prompted to verify, select Yes.
- Right click the publisher database and select Delete. Select Close existing connections and click OK.
- Open SQL Management Studio and connect to the SQL server hosting the site database.
- Right click Replication and select Disable Publishing and Distribution.
- In the Wizard, click Next.
- Select Yes, disable publishing on this server and click Next three times.
- Click Finish.
Download ConfigMgr 2012 R2 SP1 Prerequisites Files and Run the Prerequisite Checker
- Open a command prompt with administrative privileges.
- Navigate to D:\Setup\CM2012R2\SMSSETUP\BIN\X64, type SetupDL.exe D:\Setup\CMSP1, and press Enter.
- Once all files have been downloaded, type prereqchk.exe /LOCAL. Notice that you get error messages about an existing ConfigMgr installation.
- Click Cancel and close the command prompt.
- Restart the server. Although a restart is not required it’s considered a very good idea.
Upgrade Primary Site with 2012 R2 SP1
- Open a command prompt with administrative privileges.
- Navigate to D:\Setup\CMSP1\ and type splash.hta.
- Click Install.
- On the Before You Begin page, read the notes and click Next.
- On the Getting Started page, select Upgrade this Configuration Manager site and click Next.
- On the Product Key page, enter your 25-character product key, or select Install this product as an evaluation if you don’t have the key at the present time, and click Next.
- On the Microsoft Software License Terms page, click I accept these license terms and then click Next.
- On the Prerequisite Licenses page, accept the prerequisite license terms and click Next.
- On the Prerequisite Downloads page, click Use previously downloaded files; use the Browse button to select the D:\Setup\CMSP1DL folder, and click Next.
- On the Server Language Selection page, ensure that English is the only selected language and click Next.
- On the Client Language Selection page, select the client languages you wish to support in your environment and click Next.
- On the Settings Summary page, review the summary and click Next.
- On the Prerequisite Checker page, click Begin Install to start the upgrade. Notice that you do not have any SQL Server errors like you had when running the prerequisites tool.
- The upgrade process can easily take 20–40 minutes. When the upgrade is finished, click Close.
Notice that most components will be reinstalled after setup is finished. Monitor that process by reading the sitecomp.log file on the site server.
All existing clients also must be upgraded to SP1. You can use any client method to upgrade your clients.
Automatic Client Upgrade
- Select the Administration workspace.
- Navigate to Site Configuration / Sites; select PS1 and on the ribbon, click Hierarchy Settings.
- On the Automatic Client Upgrade tab, enable Upgrade client automatically when new client update are available. Read the warning message and click OK.
- In Upgrade client automatically when new client updates are available, type x-number of days and click OK.
- A scheduled task named Configuration Manager Client Upgrade Task will be created next time a client downloads the ConfigMgr machine policy.
The default boot images are being updated during the SP upgrade. If those are used make sure to get them distributed. Also replace you task sequences with the new sp1 client package.
Management point replicas
After a successful upgrade, configure the management point replicas again.
The Management Point installation has a tendency of failing during the SP upgrade. I have seen msiexec error 1603 several times.
Reinstall the management point and while monitoring mpmsi.log and mpsetup.log. A restart might also fix the problem as the management point reinstallation will automatically begin again.
Working with distributed views on the CAS – more information in this blog post from Brian Mason http://www.mnscug.org/blogs/brian-mason/402-cm12-r2-sp1-not-ready-for-distributed-views
Wait for Microsoft to release a fix
|Issues with the Object Replication Manager, failes to replicate objects.||https://social.technet.microsoft.com/Forums/en-US/2e9ba246-194d-47d4-adc9-eb3b1717bfdc/object-replication-manager-failed-to-process-object-changes?forum=configmanagergeneral|
|Issues with the NDES site system role||http://scug.be/sccm/2015/06/02/configmgr-2012-ndes-site-role-not-healthy-anymore-after-r2-sp1-upgrade/|