Geeks With Blogs

News
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
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
Requesting Gravatar...
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
Requesting Gravatar...
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
Requesting Gravatar...
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
Requesting 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?
Left by RijuV on Aug 17, 2011 4:41 AM

# re: How to Upgrade from SQL Express to SQL Enterprise Edition
Requesting Gravatar...
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:
 (will show your gravatar)


Copyright © MOSSLover | Powered by: GeeksWithBlogs.net