Solved

vCenter 5.5 SQL 2008 Express in-place Upgrade to 2008 Standard

Posted on 2016-11-10
7
32 Views
Last Modified: 2016-11-29
Hi, I have been scouring the web for an inplace upgrade of SQL 2008 express to standard, the instance holds the vcenter database and update manager database. Is it simple to follow this link for the edition to be upgraded from Express to Standard ?

https://blogs.msdn.microsoft.com/petersad/2011/01/24/how-to-perform-an-sql-server-edition-upgrade/
0
Comment
Question by:Savvy Xeus
  • 4
  • 3
7 Comments
 
LVL 117

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
ID: 41881976
Yes, just make sure you take a good valid FULL Backup (not a snapshot) before you start, so you can rollback if it all goes wrong.
0
 
LVL 1

Author Comment

by:Savvy Xeus
ID: 41882001
Thanks Andrew, the server is a physical server 2008 r2 server which till date hasn't been backed up at all. Should the vmware services be stopped when running the upgrade, I was seeing the vmware kb https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1028601

Should any of the steps listed in the kb be followed pre or post upgrade ?
0
 
LVL 117
ID: 41882006
I would stop vCenter Server and related services, whilst you upgrade.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 1

Author Comment

by:Savvy Xeus
ID: 41882345
Thanks, will be running this soon, fingers crossed. Wonder why vmware kb involves complex steps of backing up and restore db even for in place upgrades like express to standard.
0
 
LVL 1

Author Comment

by:Savvy Xeus
ID: 41887575
Just want to check if this is the same if upgrading from SQL 2008 Express to SQL 2012 Standard ?
0
 
LVL 117
ID: 41906229
do you require any additional help to close this question?
0
 
LVL 1

Author Comment

by:Savvy Xeus
ID: 41906596
thanks Andrew, the in place upgrade worked a treat.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

It Is not possible to enable LLDP in vSwitch(at least is not supported by VMware), so in this article we will enable this, and also go trough how to enabled CDP and how to get this information in vSwitches and also in vDS.
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
Teach the user how to rename, unmount, delete and upgrade VMFS datastores. Open vSphere Web Client: Rename VMFS and NFS datastores: Upgrade VMFS-3 volume to VMFS-5: Unmount VMFS datastore: Delete a VMFS datastore:
Teach the user how to install log collectors and how to configure ESXi 5.5 for remote logging Open console session and mount vCenter Server installer: Install vSphere Core Dump Collector: Install vSphere Syslog Collector: Open vSphere Client: Config…

707 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now