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

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/
LVL 3
ExchangeKBAsked:
Who is Participating?
 
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
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
 
ExchangeKBAuthor Commented:
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
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
I would stop vCenter Server and related services, whilst you upgrade.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
ExchangeKBAuthor Commented:
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
 
ExchangeKBAuthor Commented:
Just want to check if this is the same if upgrading from SQL 2008 Express to SQL 2012 Standard ?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
do you require any additional help to close this question?
0
 
ExchangeKBAuthor Commented:
thanks Andrew, the in place upgrade worked a treat.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.