Solved

In place Upgrade SQL 2008 Express to SQL 2012 Standard for vCenter

Posted on 2016-11-15
12
111 Views
Last Modified: 2016-11-17
If I want to in place upgrade SQL Server 2008 Express to SQL Server 2012 Standard, is it just stop vCenter services and insert SQL 2012 Standard install and perform the upgrade of the vCenter SQL Express database instance, or should I upgrade 2012 Express and then again perform a Edition upgrade to SQL 2012 Standard.
0
Comment
Question by:ExchangeKB
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +2
12 Comments
 
LVL 23

Assisted Solution

by:Luciano Patrão
Luciano Patrão earned 125 total points
ID: 41887716
Hi,

Yes you can upgrade directly to 2012.

Here you can see the upgrade level:

https://technet.microsoft.com/en-us/library/ms143393(v=sql.110).aspx

Maybe some information how to:

https://blogs.msdn.microsoft.com/petersad/2011/01/24/how-to-perform-an-sql-server-edition-upgrade/

Regarding vCenter, yes you need to stop all vCenter services before the upgrade.

Jail
0
 
LVL 120

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 125 total points
ID: 41887758
and make sure you take a full backup of vCenter Server and/or SQL database, should you need to roll back.

Also this was completed by a recent EE Member, and it FAILED!

e.g. vCenter Server has now been broken since the SQL in place upgrade.
1
 
LVL 7

Expert Comment

by:Andy
ID: 41887830
If it's a VM SQL server, take a snapshot first aswell as the other backups.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 120
ID: 41887914
I would not recommend a Snapshot, a VM running on a snapshot causes poor performance.
0
 
LVL 7

Expert Comment

by:Andy
ID: 41887927
Although not recommended, I've done it many times with no noticeable issues.
0
 
LVL 26

Expert Comment

by:Zberteoc
ID: 41887938
Why not install the SQL 2012 from scratch and then migrate the databases using backup/restore?
0
 
LVL 23

Expert Comment

by:Luciano Patrão
ID: 41888089
@Andrew you are right, I forget to mention that part. Always do a proper Backup of the SQL and vCenter before the upgrade.

@Zberteoc yes is the proper way. But for vCenter then you need to do same changes. Is not just backup/restore to the new SQL Server. In vCenter needs some configurations change.

So since new vCenter versions are pointing to VCSA and embedded Postgres DB, in the future maybe no need for SQL.
0
 
LVL 1

Author Comment

by:ExchangeKB
ID: 41889981
@Luciano  Just to confirm the upgrade level I can upgrade SQL 2008 R2 SP1 Express to SQL 2012 Standard SP3, does the service pack level matter ?
0
 
LVL 26

Assisted Solution

by:Zberteoc
Zberteoc earned 250 total points
ID: 41890055
You have to upgrade to SQL 2012 first and then in second step you install SP3.
0
 
LVL 1

Author Comment

by:ExchangeKB
ID: 41890096
Thanks Zberteoc

Can you point me to a step by step of inplace  upgrade of SQL 2008 R2 Express  to SQL 2012 Standard, the link previously is just a edition upgrade from 2008 express to standard.
0
 
LVL 26

Accepted Solution

by:
Zberteoc earned 250 total points
ID: 41891480
This should do it. The fact that yours is EXPRESS doesn't matter:

https://www.youtube.com/watch?v=d2SE46xaKYE
0
 
LVL 23

Expert Comment

by:Luciano Patrão
ID: 41891572
Hi

In My initial reply you have both answers. If is possible to upgrade and how to upgrade.

Service pack are always apply after the initial upgrade, or SQL install.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article, I will show you HOW TO: Create your first Windows Virtual Machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, the Windows OS we will install is Windows Server 2016.
Ransomware is a malware that is again in the list of security  concerns. Not only for companies, but also for Government security and  even at personal use. IT departments should be aware and have the right  knowledge to how to fight it.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question