Jump to content


bk_

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

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.