Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2016-11-10
7
Medium Priority
?
188 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:ExchangeKB
  • 4
  • 3
7 Comments
 
LVL 124

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 2000 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 3

Author Comment

by:ExchangeKB
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 124
ID: 41882006
I would stop vCenter Server and related services, whilst you upgrade.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 3

Author Comment

by:ExchangeKB
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 3

Author Comment

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

Author Comment

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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
Teach the user how to delpoy the vCenter Server Appliance and how to configure its network settings Deploy OVF: Open VM console and configure networking:
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…

963 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