How to Upgrade from SQL Express to SQL Enterprise Edition

News

About Me:
I am a 26 year old female SharePoint Enthusiast. I work for B&R Business Solutions from my home in Olathe, KS. 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 MOSS, attending Code Camps as a speaker, 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.

My Stats

Posts - 201
Comments - 250
Trackbacks - 0

Twitter

MossLover Researching an issue sucked...Oh well I tried for several hours...I couldn't find the answer...Work on it tomorrow... about 2 days ago

MossLover 3 nails have been cut so far in the epic cat nail cutting battle...Will I get more tune in next time...Same cat time same cat channel... about 2 days ago

MossLover I gotta get out of here...Head to coaches...Last .Net User Group event for me wouldn't miss it for the world in KC. about 2 days ago

MossLover I need a huge vacation...Luckily #spskc is taken care of for the most part... about 2 days ago

MossLover @resing Once you get your master you should walk around in a Jedi robe and we should all call you Master Resing. about 2 days ago

MossLover This floor cleaning is painful...My hands hurt...My body hurts... about 3 days ago

MossLover I hate cleaning the kitchen and bathroom but it needs to be done... about 3 days ago

MossLover RT @1kevgriff: #SPSVB has broken 100 registered! You should register today to insure a spot! http://bit.ly/34sD7s about 3 days ago

MossLover Only 35 tickets left at #spskc.With 265 registrants. about 3 days ago

MossLover @SPSherm It takes me a year or two to buy anything...So I was probably considering a tv and ps3 about last year this time. about 3 days ago

Post Categories

B&R Blogs

Kansas City Community Blogs

Other Blogs

Not So Trivial (Clint Edmonson)

SharePoint Blogs

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

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 @ Tuesday, June 10, 2008 11:20 AM | Filed Under [ MOSS .Net ]

Comments

# re: How to Upgrade from SQL Express to SQL Enterprise Edition
Posted by Steve Sullivan on 5/7/2009 12:59 PM
THANK YOU!!! Been looking everywhere for that to upgrade an express 2005 database. :)

The Guide of a MOSSLover

Becky Isserman's Blog

News

My Stats

Twitter

Tag Cloud

Recent Comments

Recent Posts

Archives

Post Categories

B&R Blogs

Kansas City Community Blogs

Other Blogs

SharePoint Blogs

How to Upgrade from SQL Express to SQL Enterprise Edition

posted @ Tuesday, June 10, 2008 11:20 AM | Filed Under [ MOSS .Net ]

Comments