Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

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/
0
ExchangeKB
Asked:
ExchangeKB
  • 4
  • 3
1 Solution
 
Andrew Hancock (VMware vExpert / EE MVE^2)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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now