How can I upgrade SQL Express with service pack 1 (on secondary site)

[bk_]

Hi guys

 

We have on our primary site a SCCM Server, which is installed on a Windows Server 2012 R2. On this server is Microsoft SQL Server 2012 with SP1 installed.
We have also an secondary site. Which has installed the Microsoft SQL Express 2012 on it (without any Service Pack).

 

When I want to upgrade the SQL Express on the secondary site to Service Pack 1, what should i pay attetion.
What I already did is - I have downloaded the SQLEXPR_x64_ENU.exe on following url: http://www.microsoft.com/en-US/download/details.aspx?id=35579

 

My question is:
How can I upgrade the SQL Express on the secondary site:
- Do I have the upgrade over the primary site?
- Can I run the download EXE file on the secondary site while running system or do I have first stop some services?

 

I hope you can help me. Thank you in advance.

[ludi2014]

HI

Are you using SQL Experss for primary site .Is some rectrictions on SQL Experss vs SQL standard.

 

Primary and secondary not host same sql database.Typicaly primary is located on Cluster/DB or local if is small setup.

Secondary has own SQL Experss database.

be shure primary sql version and secondary is same buid number.

 

kind regard

Safet Grahic

http://www.learnmesccm.com/

https://www.linkedin...ahic/a0/842/b21

[bk_]

Hi

Thank you for your answer.

On my primary site is SQL Standard installed and on my secondary site is only the SQL Express installed.

The reason why Im asking is that the version of SQL doesnt match. And now I want to upgrade the Sql Express of my secondary sote to the same version of primary.

 

Thank you

[ludi2014]

hi

 

Be shure what is supported by sccm

http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig

iCU2 is supported by a non-R2 site.

 

kind regard

Safet Grahic

http://www.learnmesccm.com/

https://www.linkedin...ahic/a0/842/b21