How to Upgrade from SQL Express to SQL Enterprise Edition

I was using a VPC today, so that I could restore our content database and keep a copy of our SharePoint instance for development.  I noticed that SQL Express only allows about 3-4 gb of data in a database.  That wouldn't work out considering our Content DB is 21.9 GB.  So I need to find a way to upgrade the SQL Server instace to SQL Enterprise Edition.  I did some research and some tweaking and figured it out.  If you open up a command prompt window and type in this information:
start /wait C:\setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=NameOfServerInstance UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
Unfortunately, if this is a production server you may experience some down time, so plan accordingly with your maintenance schedule.  If anyone has any comments or questions please let me know.
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Print | posted on Tuesday, June 10, 2008 11:20 AM

Feedback

# re: How to Upgrade from SQL Express to SQL Enterprise Edition

Left by Steve Sullivan at 5/7/2009 12:59 PM
Gravatar THANK YOU!!! Been looking everywhere for that to upgrade an express 2005 database. :)

# re: How to Upgrade from SQL Express to SQL Enterprise Edition

Left by Alan at 4/26/2011 4:53 AM
Gravatar Hi, any idea that this work fine too for SQL 2008 ?

many thks

# re: How to Upgrade from SQL Express to SQL Enterprise Edition

Left by Carl Stent at 5/27/2011 11:03 AM
Gravatar Thanks! Worked like a charm :)

# re: How to Upgrade from SQL Express to SQL Enterprise Edition

Left by RijuV at 8/17/2011 4:41 AM
Gravatar Hi Becky,

I am using sql 2008 r2 express in sharepoint farm.I would like to upgrade the sql express to enterprise edition.
could it possible with this command?

# re: How to Upgrade from SQL Express to SQL Enterprise Edition

Left by Kal at 10/22/2011 11:24 PM
Gravatar it did not work for me. I am trying to upgrade from SQl Express to SQL Enterprise 2008.

Your comment:





 
 

Copyright © MOSSLover

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski