How to Upgrade from SQL Express to SQL Enterprise Edition

Geeks With Blogs

316 Posts | 368 Comments

About Me:
I am a Female SharePoint Developer (a platinum unicorn). I have been working with SharePoint since I attended the Portal University in 2005. I hold a BA in Computer Science from the University of Missouri - Kansas City. I love playing Rockband, organizing user group meetings, working with code, attending events as a speaker or organizer, and having bizarre conversations about geek things with cool people. If you have any comments or questions fill out the contact form and I will try my best to help.

The Guide of a MOSSLover Becky Isserman's Blog

<< New Firewall Woes | Home | What I've been up To and Will be up to... >>

How to Upgrade from SQL Express to SQL Enterprise Edition

Comments (5) | Share

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. Posted on Tuesday, June 10, 2008 11:20 AM MOSS , .Net | Back to top

Comments on this post: How to Upgrade from SQL Express to SQL Enterprise Edition

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

THANK YOU!!! Been looking everywhere for that to upgrade an express 2005 database. :)

Left by Steve Sullivan on May 07, 2009 12:59 PM

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

Hi, any idea that this work fine too for SQL 2008 ?

many thks

Left by Alan on Apr 26, 2011 4:53 AM

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

Thanks! Worked like a charm :)

Left by Carl Stent on May 27, 2011 11:03 AM

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

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?

Left by RijuV on Aug 17, 2011 4:41 AM

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

it did not work for me. I am trying to upgrade from SQl Express to SQL Enterprise 2008.

Left by Kal on Oct 22, 2011 11:24 PM

Your comment:

Title:

Name:

Email: (never displayed) (will show your gravatar)

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Verification:

Code Monkey Projectiles - Index

ASP.Net SQL Server Apple Google SharePoint Windows Visual Studio Team Foundation Server Agile Office Design Patterns Web Azure