PENDING Update SQL to SP1 on SCCM server

[AlTu]

Hi,

I have upgraded my SCCM 2012 R2 SP1 to SCCM Current Branch 1606 successfully.
Then I wanted to do an in-place upgrade to the latest version, 1610.
The prerequisites check gave me a warning.

[Completed with warning]:Checks for supported SQL Server version

I have one primary site with SQL Server 2012 with SP1 (version 11.0.3000.0).
For SCCM 1610 I need at least SQL 2012 SP2.

My question is:
Are there any special things I need to pay attention to when upgrading SQL on the SCCM server?
Any guide that I have to follow?
Some services or tasks I need to stop while upgrading?
Or can I just go ahead and install it, reboot, and everything will work?

Thanks

 

[Prajwal Desai]

My suggestion would be take a backup of your DB's. To be on a safer side if you have SCCM+SQL installed on one machine, take a full backup of machine. For SQL upgrade, check the fourth link below.

https://prajwaldesai.com/how-to-backup-sccm-2012-r2-server/
https://prajwaldesai.com/supported-sql-server-versions-sccm-current-branch/
https://stevethompsonmvp.wordpress....up-recommendations-for-configuration-manager/
https://prajwaldesai.com/sccm-1606-upgrade-sql-server-2014-sql-server-2016/

 

[AlTu]

Thank you very much Prajwal.
I appreciate your help.

So basically, other than a backup is not necessary?
Once I have a backup I could go ahead and update SQL Server without any other prerequistes.

 

[AlcSilian]

I installed the SP 1 update on my SCCM machine with no problem. Thing is that you must update manualy and not via SCCM. All is OK!

 

[AlTu]

I installed the SP 1 update on my SCCM machine with no problem. Thing is that you must update manualy and not via SCCM. All is OK!

It's actually SP2, I mistyped in the title.

So you installed the Service Pack, rebooted, and all worked fine?