I am planning to upgrade SCCM R2 to SCCM SP2

Let me know the precautions need to take, requirements for SCCP SP2,

Last time when I tried to upgrade, I got an error as SQL Server process memory allocation, then installation stops going further

please share me the details to upgrade successfully

Thank in Advance...

NTRao

You need to upgrade from R2 to R2 SP1.  There's been a bit of confusion around the R2 to R2 SP1 and SP1 to SP2 releases.

This guide should assist you

http://www.systemcenterdudes.com/sccm-2012-r2-sp1-upgrade/

Regards the SQL memory allocation. You should only be warned about this and it shouldn't stop you upgrading. However if you are running SQL locally then you need to configure SQL to use 50% of memory. Make sure this has been set.

Microsoft Release SCCM 2012 updates as below flow:

1> SCCM 2012 Beta 1 > Beta 2 > Release Candidate 1  > Release Candidate 2

then

2> SCCM 2012 RTM > CU1 > CU2

then

3> SCCM 2012 SP1(Service Pack) Beta > SP1 > SP1 CU1 > SP1 CU2 > SP1 CU3 > SP1 CU4 > SP1 CU5

then

4> SCCM 2012 R2(Release 2) > R2 CU1 > R2 CU2 > R2 CU3 > R2 CU4 > R2 CU5

then

5> SCCM 2012 R2 SP1

So if you have SCCM 2012 R2 in your environment, its better to update it with R2 SP1 released recently. Before doing such activity in production, kindly test it in test lab. Once done successfully, you can do it in production.

I also suggest you to prepare document on such activity.

For SQL Server memory allocation, I suggest to got for 75% for SQL Server and 25% for System. You can configure it using SQL Server Management Studio.

• Edited by Kiran Kr Tamang 1 hour 43 minutes ago