Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2016-11-10
7
Medium Priority
?
182 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
[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
  • 4
  • 3
7 Comments
 
LVL 123

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 123
ID: 41882006
I would stop vCenter Server and related services, whilst you upgrade.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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 123
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

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: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
Teach the user how to convert virtaul disk file formats and how to rename virtual machine files on datastores. Open vSphere Web Client: Review VM disk settings: Migrate VM to new datastore with a thick provisioned (lazy zeroed) disk format: Rename a…
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

722 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